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