Re: Major Performance decrease after some hours

MaXX wrote:
>> There are 10-15 postmaster processes running which use all the CPU
>> power.
>> A restart of tomcat and then postgresql results in the same situation.
>> Some postgres processes are in DELETE waiting or SELECT waiting.
>> VACUUM runs through in just about 1-2 seconds and is run via cron
>> every minute and reports that the fsm setting are high enough.
>
> Pure speculation: are you sure you aren't vacuuming too agressively?

Have you tried autovacuum?  You can manually tweak the settings so that
your hot spot tables are vacuumed aggressivly.  One of the main upsides
to autovacuum is tha tit saves cycles, that is, it only vacuums when you
need it.