Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id F2CD59FB807 for ; Thu, 30 Aug 2007 14:32:15 -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 28177-03-3 for ; Thu, 30 Aug 2007 14:32:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D073B9FB812 for ; Thu, 30 Aug 2007 14:32:05 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 0D5D656480; Thu, 30 Aug 2007 17:31:57 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Thu, 30 Aug 2007 12:31:51 -0500 Date: Thu, 30 Aug 2007 12:31:51 -0500 From: Decibel! To: Ruben Rubio Cc: Bill Moran , Chris Mair , pgsql-performance@postgresql.org Subject: Re: [Solved] Postgres performance problem Message-ID: <20070830173151.GP38801@decibel.org> References: <46D2B879.6010308@rentalia.com> <46D2C4AF.8090501@1006.org> <20070827092935.be819c94.wmoran@collaborativefusion.com> <46D67730.10505@rentalia.com> <46D692CC.7010907@rentalia.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="JcvBIhDvR6w3jUPA" Content-Disposition: inline In-Reply-To: <46D692CC.7010907@rentalia.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070830:ruben@rentalia.com::Rz1Y0EVjTCzCGzBs:0000000000000000000 0000000000000000000000004mW2 X-Hashcash: 1:20:070830:wmoran@collaborativefusion.com::L5u0bmpggWDzlUEU:0000000 000000000000000000000000B9to X-Hashcash: 1:20:070830:chris@1006.org::UuFjb+L7GV0eOD25:0001k2k X-Hashcash: 1:20:070830:pgsql-performance@postgresql.org::+Bni/Z0oH6oH6/Hg:00000 0000000000000000000000009BlN X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/393 X-Sequence-Number: 26523 --JcvBIhDvR6w3jUPA Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Aug 30, 2007 at 11:50:04AM +0200, Ruben Rubio wrote: > 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. >=20 > 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. >=20 > 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. No, it sounds to me like you just weren't vacuuming aggressively enough to keep up with demand. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --JcvBIhDvR6w3jUPA Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFG1v8HdO30qud8SkgRAqlVAKDbNKRoyn1QPl0BWdVqstQWQPfrfACgm719 +VaHgg9JkPIw27EULubqM7Y= =QYaL -----END PGP SIGNATURE----- --JcvBIhDvR6w3jUPA--