Message-ID: <46EE6C7B.7070706@rentalia.com>
Date: Mon, 17 Sep 2007 14:00:59 +0200
From: Ruben Rubio <ruben@rentalia.com>
User-Agent: Thunderbird 1.5.0.13 (X11/20070824)
MIME-Version: 1.0
To: "Gavin M. Roy" <gmr@ehpg.net>
CC: pgsql-performance@postgresql.org
Subject: Re: [Again] Postgres performance problem
References: <46E636CB.8080008@rentalia.com>
	<af1bce590709130831r679a8d63q7ad289804879f1f5@mail.gmail.com>
In-Reply-To: <af1bce590709130831r679a8d63q7ad289804879f1f5@mail.gmail.com>
Content-Type: multipart/mixed; boundary="------------090503020307070505010309"

This is a multi-part message in MIME format.
--------------090503020307070505010309
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

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


Gavin M. Roy escribió:
> How many backends do you have at any given time?  Have you tried using
> something like pgBouncer to lower backend usage?  How about your IO
> situation?  Have you run something like sysstat to see what iowait is
> at?

backends arround 50 -100 I don't use pgBouncer yet.
Sysstat reports veeery low io.

Right now Im checking out fsm parameter, as Scott recomended. Seems
there is the problem.


> 
> On 9/11/07, Ruben Rubio <ruben@rentalia.com> wrote:
> 
> Hi,
> 
> I having the same problem I told here a few weeks before. Database is
> using too much resources again.
> 
> I do a vacumm full each day, but seems it is not working. I am preparing
> an update to postgres 8.2.4 (actually I am using at 8.1.3, and tests for
> update will need several days)
> 
> 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?
> 
> Thanks in advance,
> 
> 
> 
>>
>>
- ---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
>>
>>
>>

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

iD8DBQFG7mx7Io1XmbAXRboRAn0VAJ4sGc1KCNlsbrybVbY/WfB+3XWBbwCfb7Z/
WNGyJCRo6zd26uR6FB6SA8o=
=SYzs
-----END PGP SIGNATURE-----

--------------090503020307070505010309
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


--------------090503020307070505010309--