Re: [BUGS] Rapid deteriation of performance (might be caused by

On Fri, 4 Apr 2003, Robert John Shepherd wrote:

> Up until a few days ago I have been running Postgresl 7.2.3 with Tsearch
> from the contrib dir, but at various times the performance of the
> database would suddenly and rapidly deteriate so that queries which
> previously took 500ms then took 8 or 9 seconds.

Hmm, what are the before and after explain analyze results?  Also, what
are your conf settings for shared buffers, sort memory and the fsm
parameters?

> The only cure is a backup and restore of the database, vacuuming and
> analysing does nothing. I even tried rebuilding all indexes once which
> didn't seem to help.

Did you do a regular vacuum or vacuum full?  If only the former, it's
possible that you need to either vacuum more frequently and/or raise the
free space map settings in your configuration file.

What does vacuum full verbose <table>; give you for the tables involved?

> Help! (And sorry if this is the wrong list)
pgsql-performance is a better list, so I've replied to there.  You'll
probably need to join in order to reply to list.