Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 5EEA79F9E3F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sat,  6 Oct 2007 00:14:50 -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 40947-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sat,  6 Oct 2007 00:14:40 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51])
	by postgresql.org (Postfix) with ESMTP id 4BC2E9F9E17
	for <pgsql-performance@postgresql.org>;
	Sat,  6 Oct 2007 00:14:40 -0300 (ADT)
Received: by tamriel.snowman.net (Postfix, from userid 1000)
	id 8BF8584116; Fri,  5 Oct 2007 23:14:38 -0400 (EDT)
Date: Fri, 5 Oct 2007 23:14:38 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: 'PostgreSQL Performance' <pgsql-performance@postgresql.org>
Subject: Re: query plan worse after analyze
Message-ID: <20071006031438.GE5031@tamriel.snowman.net>
Mail-Followup-To: Jeff Frost <jeff@frostconsultingllc.com>,
	'PostgreSQL Performance' <pgsql-performance@postgresql.org>
References: <029201c807bc$f1642f60$120a0a0a@jefflap>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="so9zsI5B81VjUb/o"
Content-Disposition: inline
In-Reply-To: <029201c807bc$f1642f60$120a0a0a@jefflap>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/2.6.22-2-amd64 (x86_64)
X-Uptime: 23:12:45 up 5 days,  3:25, 18 users,  load average: 0.01, 0.17, 0.11
User-Agent: Mutt/1.5.16 (2007-06-11)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/64
X-Sequence-Number: 27086


--so9zsI5B81VjUb/o
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

* Jeff Frost (jeff@frostconsultingllc.com) wrote:
> Here are the plans:

It's probably just me but, honestly, I find it terribly frustrating to
try and read a line-wrapped explain-analyze output...  I realize it
might not be something you can control in your mailer, but you might
consider putting the various plans up somewhere online (perhaps a
pastebin like http://pgsql.privatepaste.com) instead of or in addition
to sending it in the email.

	Thanks!

		Stephen

--so9zsI5B81VjUb/o
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHBv2erzgMPqB3kigRAj9aAJsFLhr2O+qEc8REbmKEdniA61SiigCfTTSv
SfEuf4UL9uVuojjmTvsmCOE=
=276I
-----END PGP SIGNATURE-----

--so9zsI5B81VjUb/o--