On Sat, 05 Apr 2003 16:39:42 +0200, fred-pg(at)jolliton(dot)com wrote:
>I have a table with 3000 rows (this number is almost constant, and
>never decrease)
>A stored procedure (PL/pgSQL) is called with an average of 14 times
>per seconds and, 99% of the time, this result on one SELECT followed
>by an UPDATE on table "data".
So there are almost 900 updates per minute.
Do a VACUUM FULL once and then a VACUUM every minute. From time to
time do ANALYSE or VACUUM ANALYSE. MAX_FSM_RELATIONS should be no
problem, but make sure that MAX_FSM_PAGES is not too low.
Servus
Manfred