| 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: | Whole Thread | Raw Message | 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 |