From: Ruben Rubio <ruben@rentalia.com>
To: db@zigo.dhs.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [Again] Postgres performance problem
Date: Tue, 11 Sep 2007 09:49:37 +0200
Message-ID: <46E64891.9080005@rentalia.com> (raw)
In-Reply-To: <43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org>
References: <46E636CB.8080008@rentalia.com>
<43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org>
-----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-----
Attachments:ruben.vcf (text/x-vcard, 244B) download
begin:vcard
fn:Ruben Rubio
n:Rubio;Ruben
org:Rentalia Holidays S.L
adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain
email;internet:ruben@rentalia.com
tel;work:+34915233104
url:http://www.rentalia.com
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ruben@rentalia.com, db@zigo.dhs.org
Subject: Re: [Again] Postgres performance problem
In-Reply-To: <46E64891.9080005@rentalia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox