Re: Still confused about VACUUM vs. VACUUM FULL

On Thu, 2003-06-12 at 12:42, Tom Lane wrote:
> 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.
>

We've gone from daily, to twice daily, to several times during the "peak
updates" period, and back to twice daily.

We're also ANALYZE-ing the largest 12-18 tables on a cycle: every twenty
minutes, a daemon wakes up and ANALYZEs until they're all done or two
minutes has elapsed, whichever comes first.

max_fsm_relations = 200
max_fsm_pages = 350000

We have around 220 tables total, only 40 of which have more than 1000
pg_class.reltuples.

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise