Re: Autovacuum, too often?
| От | Harald Armin Massa |
|---|---|
| Тема | Re: Autovacuum, too often? |
| Дата | |
| Msg-id | 7be3f35d0809190440y6252eef7hf318fa087f67e4dd@mail.gmail.com обсуждение исходный текст |
| Ответ на | Autovacuum, too often? (Glyn Astill <glynastill@yahoo.co.uk>) |
| Ответы |
Re: Autovacuum, too often?
|
| Список | pgsql-general |
Hello Glyn,
and what is the problem with this usage? That is a perfectly valid thing to do; PostgreSQL can handle that for centuries; no need to kick the developers :)
That is the right thing to do.
As you described, that temp-tables get filled and cleared regularly ... that is "insert <a lot of stuff>" "delete <the same stuff again>"; so there are lots of "unused" i.e. deleted tuples, which get recycled by your vacuuming. And that with nearly no CPU usage.
Sounds fine to me :)
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
Our legacy apps have some permanent tables that they use for tempory data and constantly clear out, I've kicked the developers and I intend to eradicate them eventually (the tables, not the developers).
and what is the problem with this usage? That is a perfectly valid thing to do; PostgreSQL can handle that for centuries; no need to kick the developers :)
These tables are constantly being autovacuumed, approximately once a minute, it's not causing any problem and seems to be keeping them vacuumed.
That is the right thing to do.
pages: 21 removed, 26 remain
tuples: 2356 removed, 171 remain
system usage: CPU 0.00s/0.00u sec elapsed 0.08 sec
Sounds fine to me :)
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
EuroPython 2009 will take place in Birmingham - Stay tuned!
В списке pgsql-general по дате отправления: