Re: Query sometimes takes down server

From: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(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:19:30
Message-ID: 4970EBD2.4090206@supernovasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-01-16 20:23:27 Re: Query sometimes takes down server
Previous Message Scott Marlowe 2009-01-16 20:15:40 Re: Questions regarding indexes