Re: [Again] Postgres performance problem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

db@zigo.dhs.org escribió:
>> Last time I had this problem i solved it stopping website,  restarting
>> database, vacuumm it, run again website. But I guess this is going to
>> happen again.
>>
>> I would like to detect and solve the problem. Any ideas to detect it?
>
> Do you have very long transactions? Maybe some client that is connected
> all the time that is idle in transaction?

There should not be long transactions. I ll keep an eye on Idle transactions

I m detecting it using:

echo 'SELECT current_query  FROM pg_stat_activity;' |
/usr/local/pgsql/bin/psql vacadb  | grep IDLE | wc -l



>
> /Dennis
>
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG5kiRIo1XmbAXRboRAj3sAKCH21zIhvdvPcmVQG71owiCye96xwCcDPe0
o/aArJF0JjUnTIFd1sMYD+Y=
=6zyY
-----END PGP SIGNATURE-----