Message-ID: <46E636CB.8080008@rentalia.com>
Date: Tue, 11 Sep 2007 08:33:47 +0200
From: Ruben Rubio <ruben@rentalia.com>
User-Agent: Thunderbird 1.5.0.13 (X11/20070824)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: [Again] Postgres performance problem
Content-Type: multipart/mixed; boundary="------------020107050005090400090409"

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

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


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,


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

iD8DBQFG5jbLIo1XmbAXRboRArcpAJ0YvoCT6KWv2fafVAtapu6nwFmKoACcD0uA
zFTx9Wq+2NSxijIf/R8E5f8=
=u0k5
-----END PGP SIGNATURE-----

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


--------------020107050005090400090409--