Condor con...@stz-bg.com writes:
today when I do select relname, last_autovacuum, last_vacuum from
pg_stat_all_tables I see last_vacuum and autovacuum fields is empty.
This its seems strange for me, because every night crontab start at
01:10 am a vacuum script that do:
reindex, vacuum full
On 15.05.2012 14:07, Tom Lane wrote:
Condor con...@stz-bg.com writes:
today when I do select relname, last_autovacuum, last_vacuum from
pg_stat_all_tables I see last_vacuum and autovacuum fields is empty.
This its seems strange for me, because every night crontab start at
01:10 am a vacuum
On 05/15/2012 05:30 AM, Condor wrote:
O
I use vacuum full because I have huge tables that every night is
deleted (truncated)
and I want my space back.
Truncate does reclaim space. Bulk deletes do not. If you are doing bulk
deletes since you need to delete *almost* everything consider using