Re: Query sometimes takes down server

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Jeff Davis" <pgsql(at)j-davis(dot)com>
Cc: "Jason Long" <mailing(dot)list(at)supernovasoftware(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query sometimes takes down server
Date: 2009-01-16 19:28:10
Message-ID: dcc563d10901161128q5e7a975dr873d22b2f8b9d805@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-01-16 19:39:09 Re: Questions regarding indexes
Previous Message Jeff Davis 2009-01-16 19:04:37 Re: Query sometimes takes down server