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
On 15.05.2012 14:07, Tom Lane wrote:
Condor 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:
reinde
Condor 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 and vacuum an
