On 08/16/2012 04:33 PM, Anibal David Acosta wrote:
Hi,
if I have a table that daily at night is deleted about 8 millions of
rows (table maybe has 9 millions) is recommended to do a vacuum
analyze after delete completes or can I leave this job to autovacuum?
This table is very active during the day but less active during night
I think that the only only thing where Postgres is weak, is in this
area (table and index bloat).
For some reason for the same amount of data every day postgres consume
a little more.
Check out pg_reorg.
cheers
andrew
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
