From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "Jason Long" <mailing(dot)list(at)supernovasoftware(dot)com> |
Cc: | "Jeff Davis" <pgsql(at)j-davis(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query sometimes takes down server |
Date: | 2009-01-16 20:23:27 |
Message-ID: | dcc563d10901161223x7a1c7bbcq632e6982bb713dcf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Weird. I wonder if the attachment is too big and the mailing list
server is chopping it off of the email.
On Fri, Jan 16, 2009 at 1:19 PM, Jason Long
<mailing(dot)list(at)supernovasoftware(dot)com> wrote:
> Scott Marlowe wrote:
>
> On Thu, Jan 15, 2009 at 11:04 PM, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
>
>
> On Thu, 2009-01-15 at 19:37 -0600, Jason Long wrote:
>
>
> I have not looked into the detail of the explain, and I do see visually
> that very different plans are being chosen.
>
>
>
> It would help to share these plans with us...
>
>
>
> See EXPLAIN ANALYZE below for three different plans @ .5, 6, and 84
> seconds
>
>
> Jason, note that the post with explain analyze didn't make it to the
> mailing list, so you're effectively leaving everyone else who could
> give you advice out of the conversation.
>
>
> I just sent it again. I wonder why it did not make it. Hopefully this one
> will. Please let me know if this one does not either.
>
--
When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-01-16 20:23:35 | Re: Questions regarding indexes |
Previous Message | Jason Long | 2009-01-16 20:19:30 | Re: Query sometimes takes down server |