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.