From: Ruben Rubio <ruben@rentalia.com>
To: ruben@rentalia.com
Cc: Bill Moran <wmoran@collaborativefusion.com>
Cc: Chris Mair <chris@1006.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: [Solved] Postgres performance problem
Date: Thu, 30 Aug 2007 11:50:04 +0200
Message-ID: <46D692CC.7010907@rentalia.com> (raw)
In-Reply-To: <46D67730.10505@rentalia.com>
References: <46D2B879.6010308@rentalia.com>
<46D2C4AF.8090501@1006.org>
<20070827092935.be819c94.wmoran@collaborativefusion.com>
<46D67730.10505@rentalia.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi ...
Seems its solved. But the problem is not found.
As you may know, I do a vacuum full and a reindex database each day. I
have logs that confirm that its done and I can check that everything was
fine.
So, this morning, I stopped the website, I stopped database, started it
again. (I was around 200 days without restarting), then I vacuum
database and reindex it (Same command as everyday) . Restart again, and
run again the website.
Now seems its working fine. But I really does not know where is the
problem. Seems vacuum its not working fine? Maybe database should need
a restart? I really don't know.
Does someone had a similar problem?
Thanks in advance,
Ruben Rubio
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG1pLMIo1XmbAXRboRAqgQAKCkWcZYE8RDppEVI485wDLnIW2SfQCfV+Hj
e8PurQb2TOSYDPW545AJ83c=
=dQgM
-----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, wmoran@collaborativefusion.com, chris@1006.org
Subject: Re: [Solved] Postgres performance problem
In-Reply-To: <46D692CC.7010907@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