Skip site navigation (1) Skip section navigation (2)

Re: Nested Loop

From: Ragnar <gnari(at)hive(dot)is>
To: Gauri Kanekar <meetgaurikanekar(at)gmail(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Nested Loop
Date: 2007-03-26 16:22:33
Message-ID: 1174926153.1153.31.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
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

> 


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2007-03-27 03:37:18
Subject: Re: [GENERAL] ERROR: out of shared memory
Previous:From: Dave DutcherDate: 2007-03-26 15:38:12
Subject: Re: Nested Loop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group