Re: reindex/vacuum locking/performance?

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: <josh(at)agliodbs(dot)com>, "Rob Nagler" <nagler(at)bivio(dot)biz>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: reindex/vacuum locking/performance?
Date: 2003-10-04 00:14:50
Message-ID: LFEIJBEOKGPDHCEMDGNFAEOGCFAA.matt@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > Also, if you find that you need to run VACUUM FULL often, then
> > you need to
> > raise your max_fsm_pages.
>
> Yes and no. If it's run often enough then the number of tracked pages
> shouldn't need to be raised, but then again...

Oops, sorry, didn't pay attention and missed the mention of FULL. My bad,
ignore my OT useless response.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-10-04 01:39:40 Re: Tuning/performance issue...
Previous Message Neil Conway 2003-10-03 23:48:07 Re: reindex/vacuum locking/performance?