Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 853BD9FA1AC for ; Tue, 11 Sep 2007 04:49:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 61378-10 for ; Tue, 11 Sep 2007 04:49:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.rentalia.com (mail.rentalia.com [213.192.209.8]) by postgresql.org (Postfix) with ESMTP id 0B22D9F9E89 for ; Tue, 11 Sep 2007 04:49:45 -0300 (ADT) Received: (qmail 9700 invoked by uid 509); 11 Sep 2007 09:49:43 +0200 Received: from 212.145.220.117 by nemo (envelope-from , uid 507) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.7/2476. spamassassin: 3.0.6. perlscan: 1.25-st-qms. Clear:RC:0(212.145.220.117):SA:0(-2.6/5.0):. Processed in 0.636769 secs); 11 Sep 2007 07:49:43 -0000 X-Antivirus-MYDOMAIN-Mail-From: ruben@rentalia.com via nemo X-Antivirus-MYDOMAIN: 1.25-st-qms (Clear:RC:0(212.145.220.117):SA:0(-2.6/5.0):. Processed in 0.636769 secs Process 9689) Received: from pooladsl-a-29-117.ipcom.comunitel.net (HELO ?192.168.2.48?) (ruben@rentalia.com@212.145.220.117) by mail.rentalia.com with SMTP; 11 Sep 2007 09:49:42 +0200 Message-ID: <46E64891.9080005@rentalia.com> Date: Tue, 11 Sep 2007 09:49:37 +0200 From: Ruben Rubio User-Agent: Thunderbird 1.5.0.13 (X11/20070824) MIME-Version: 1.0 To: db@zigo.dhs.org CC: pgsql-performance@postgresql.org Subject: Re: [Again] Postgres performance problem References: <46E636CB.8080008@rentalia.com> <43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org> In-Reply-To: <43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org> X-Enigmail-Version: 0.94.2.0 Content-Type: multipart/mixed; boundary="------------040605060106000105060208" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/175 X-Sequence-Number: 26720 This is a multi-part message in MIME format. --------------040605060106000105060208 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit -----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----- --------------040605060106000105060208 Content-Type: text/x-vcard; charset=utf-8; name="ruben.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="ruben.vcf" 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 --------------040605060106000105060208--