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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Questions regarding indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Questions regarding indexes