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.
