Search Postgresql Archives

Re: Query sometimes takes down server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxxx> wrote:
> Scott Marlowe wrote:
>
> On Thu, Jan 15, 2009 at 11:04 PM, Jeff Davis <pgsql@xxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux