| From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
|---|---|
| To: | "Bohdan Linda" <bohdan(dot)linda(at)seznam(dot)cz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Vacuuming on heavily changed databases |
| Date: | 2008-05-19 14:59:42 |
| Message-ID: | 7be3f35d0805190759w2b9f5fe7x274929555a89ffc@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
> I would like to ask an opinion on vacuuming general. Imagine situation
> that you have single table with 5 fields (one varchar). This table has
> during the day
>
> - cca 620 000 inserts
> - 0 updates
> - cca 620 000 deletes
>
> The table is vacuumed daily, but somehow after several months I got to
> size of ~50GB
do not vacuum DAILY. set up autovacuum to run AT LEAST every minute.
autovacuum will flag the "deleted" rows as to be reusable by next
insert. Make sure to use 8.3.<latest>, it's much more easy to setup
autovacuum then before.
best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pidgeon
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2008-05-19 15:19:07 | Re: Vacuuming on heavily changed databases |
| Previous Message | Bohdan Linda | 2008-05-19 14:50:18 | Vacuuming on heavily changed databases |