Re: Query sometimes takes down server - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Query sometimes takes down server
Date
Msg-id dcc563d10901161223x7a1c7bbcq632e6982bb713dcf@mail.gmail.com
Whole thread Raw
In response to Query sometimes takes down server  (Jason Long <mailing.list@supernovasoftware.com>)
Responses Re: Query sometimes takes down server  (Jason Long <mailing.list@supernovasoftware.com>)
List 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.list@supernovasoftware.com> wrote:
> Scott Marlowe wrote:
>
> On Thu, Jan 15, 2009 at 11:04 PM, Jeff Davis <pgsql@j-davis.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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Questions regarding indexes
Next
From: Tom Lane
Date:
Subject: Re: Questions regarding indexes