Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4181E9F9F2B for ; Mon, 17 Sep 2007 09:27:48 -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 47234-01 for ; Mon, 17 Sep 2007 09:27:44 -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 6AC749F9F1C for ; Mon, 17 Sep 2007 09:27:44 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 44559564BA; Mon, 17 Sep 2007 12:27:41 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Mon, 17 Sep 2007 07:27:39 -0500 Date: Mon, 17 Sep 2007 07:27:39 -0500 From: Decibel! To: Greg Smith Cc: pgsql-performance@postgresql.org Subject: Re: [Again] Postgres performance problem Message-ID: <20070917122735.GK16759@decibel.org> References: <46E636CB.8080008@rentalia.com> <43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org> <46E64891.9080005@rentalia.com> <20070911225242.GG38801@decibel.org> <46E79865.906@rentalia.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="FLPM4o+7JoHGki3m" Content-Disposition: inline In-Reply-To: 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:070917:gsmith@gregsmith.com::NxyECvwoTFURvPn7:00000000000000000 0000000000000000000000004Etw X-Hashcash: 1:20:070917:pgsql-performance@postgresql.org::0x86+tGI07CjV1We:00000 00000000000000000000000034MW X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/292 X-Sequence-Number: 26837 --FLPM4o+7JoHGki3m Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Sep 13, 2007 at 01:58:10AM -0400, Greg Smith wrote: > On Wed, 12 Sep 2007, Scott Marlowe wrote: >=20 > >I'm getting more and more motivated to rewrite the vacuum docs. I think= =20 > >a rewrite from the ground up might be best... I keep seeing people=20 > >doing vacuum full on this list and I'm thinking it's as much because of= =20 > >the way the docs represent vacuum full as anything. >=20 > I agree you shouldn't start thinking in terms of how to fix the existing= =20 > documentation. I'd suggest instead writing a tutorial leading someone=20 > through what they need to know about their tables first and then going=20 > into how vacuum works based on that data. Take a look at the stuff at http://decibel.org/~decibel/pervasive/, it'd hopefully provide a useful starting point. --=20 Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org=20 Give your computer some brain candy! www.distributed.net Team #1828 --FLPM4o+7JoHGki3m Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFG7nK3dO30qud8SkgRAp4fAKCnj8v8Lq+uNr/vMr/fHCNaDlv27ACfWwXA MSu4PBo9tIjh8S+8ltZUFFg= =j6wC -----END PGP SIGNATURE----- --FLPM4o+7JoHGki3m--