Postgres Pro
Downloads
Home   >   mailing lists

Re: reindex/vacuum locking/performance? - Mailing list pgsql-performance

From Matt Clark
Subject Re: reindex/vacuum locking/performance?
Date
Msg-id LFEIJBEOKGPDHCEMDGNFAEOGCFAA.matt@ymogen.net
Whole thread Raw
In response to Re: reindex/vacuum locking/performance?  ("Matt Clark" <matt@ymogen.net>)
List pgsql-performance
Tree view 
> > 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.

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: reindex/vacuum locking/performance?
Next
From: Bruce Momjian
Date:
Subject: Re: Tuning/performance issue...