[PERFORM] About pg_stat_activity

Hi, im César, im developing an app that saves information included in "pg_stat_activity" view in order to monitor querys. The objective of this app is to gather information about querys that take to long to finish and overload the server. I was wandering if I could see somehwere the implementation

[PERFORM] Server Configuration

Hi, I have a Server with Fedora Core 11, Tomcat and Postgresql 8.3. With Hardware: * 8GB RAM * 8 processors Intel Xeon E5520 @2.27GHz * 250GB SATA DISK Actually, it serves at most 250 connections. The problem happends when it serves many many connections at a time, tables and queries began to get

[PERFORM] Unblock tables

Hi, I wanted to know, if there is some configuration in order tables dont get blocked for too long time?