От: Ragnar
Тема: Re: Nested Loop
Дата: ,
Msg-id: 1174926153.1153.31.camel@localhost.localdomain
(см: обсуждение, исходный текст)
Ответ на: Re: Nested Loop  ("Gauri Kanekar")
Ответы: Re: Nested Loop  ("Gauri Kanekar")
Список: pgsql-performance

Скрыть дерево обсуждения

Nested Loop  ("Gauri Kanekar", )
 Re: Nested Loop  (Michael Fuhr, )
  Re: Nested Loop  ("Gauri Kanekar", )
   Re: Nested Loop  ("Dave Dutcher", )
   Re: Nested Loop  (Ragnar, )
    Re: Nested Loop  ("Gauri Kanekar", )
     Re: Nested Loop  (Ragnar, )

On mán, 2007-03-26 at 20:33 +0530, Gauri Kanekar wrote:

you did not show your query, nor did you answer whather you had vacuumed
and analyzed.

> enable_seqscan = off

why this? this is unlikely to help

> ...
>                                  ->  Nested Loop
> (cost=0.00..1104714.83 rows=6801 width=44) (actual
> time=1820.153..229779.814 rows=10945938 loops=1)

the estimates are way off here. you sure you have analyzed?



В списке pgsql-performance по дате сообщения:

От: Ragnar
Сообщение: Re: Nested Loop
От: Tom Lane
Сообщение: Re: [GENERAL] ERROR: out of shared memory