Jeff Boes <jboes(at)nexcerpt(dot)com> writes:
> For large (>1 million rows) tables
> which have a pretty high turn-over (average life span of a row is 3
> days), should there be any query performance differences whether you
> VACUUM FULL or not?
How often do you VACUUM? Do you have enough FSM space to support the
number of pages that get dirtied between vacuums? If you don't, the
physical table size will bloat over time, leading to progressive
slowdown.
regards, tom lane