From: Ragnar
Subject: Re: Nested Loop
Date: ,
Msg-id: 1174926153.1153.31.camel@localhost.localdomain
(view: Whole thread, Raw)
In response to: Re: Nested Loop  ("Gauri Kanekar")
Responses: Re: Nested Loop  ("Gauri Kanekar")
List: pgsql-performance

Tree view

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


>
> QUERY PLAN
> ...
>                                  ->  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?

gnari

>



pgsql-performance by date:

From: Ragnar
Date:
Subject: Re: Nested Loop
From: Tom Lane
Date:
Subject: Re: [GENERAL] ERROR: out of shared memory