From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | "'PostgreSQL Performance'" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: query plan worse after analyze |
Date: | 2007-10-06 04:12:20 |
Message-ID: | Pine.LNX.4.64.0710052109080.4620@discord.home.frostconsultingllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Fri, 5 Oct 2007, Stephen Frost wrote:
> * Jeff Frost (jeff(at)frostconsultingllc(dot)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.
It's not you. In fact, after I sent this and saw what it looked like, I put
it into a txt file and replied with an attachment. Unfortunately, it didn't
bounce, nor did it show up on the list. :-(
So, here's a pastebin...it's a bit better:
--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-06 05:50:03 | Re: query plan worse after analyze |
Previous Message | Rodrigo De León | 2007-10-06 03:58:51 | Re: query plan worse after analyze |