Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 508CF9F9574
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 30 Aug 2007 06:50:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 43124-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 30 Aug 2007 06:50:13 -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 E5D609F954E
	for <pgsql-performance@postgresql.org>;
	Thu, 30 Aug 2007 06:50:12 -0300 (ADT)
Received: (qmail 24865 invoked by uid 509); 30 Aug 2007 11:50:10 +0200
Received: from 212.145.220.117 by nemo (envelope-from <ruben@rentalia.com>,
	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.825122 secs); 30 Aug 2007 09:50:10 -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.825122 secs Process 24768)
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; 30 Aug 2007 11:50:09 +0200
Message-ID: <46D692CC.7010907@rentalia.com>
Date: Thu, 30 Aug 2007 11:50:04 +0200
From: Ruben Rubio <ruben@rentalia.com>
User-Agent: Thunderbird 1.5.0.12 (X11/20070604)
MIME-Version: 1.0
To: ruben@rentalia.com
CC: Bill Moran <wmoran@collaborativefusion.com>, Chris Mair <chris@1006.org>,
	pgsql-performance@postgresql.org
Subject: Re: [Solved] Postgres performance problem
References: <46D2B879.6010308@rentalia.com>	<46D2C4AF.8090501@1006.org>
	<20070827092935.be819c94.wmoran@collaborativefusion.com>
	<46D67730.10505@rentalia.com>
In-Reply-To: <46D67730.10505@rentalia.com>
X-Enigmail-Version: 0.94.2.0
Content-Type: multipart/mixed; boundary="------------030208000701020401030606"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/392
X-Sequence-Number: 26522

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

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

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


--------------030208000701020401030606--