Re: Query sometimes takes down server
От | Scott Marlowe |
---|---|
Тема | Re: Query sometimes takes down server |
Дата | |
Msg-id | dcc563d10901161223x7a1c7bbcq632e6982bb713dcf@mail.gmail.com обсуждение исходный текст |
Ответ на | Query sometimes takes down server (Jason Long <mailing.list@supernovasoftware.com>) |
Ответы |
Re: Query sometimes takes down server
|
Список | 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 по дате отправления: