Re: Query sometimes takes down server

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

In response to

Responses

Browse pgsql-general by date

  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