Re: Anti join miscalculates row number? - Mailing list pgsql-performance

From Julius Tuskenis
Subject Re: Anti join miscalculates row number?
Date
Msg-id 4EA90242.5040109@nsoft.lt
Whole thread Raw
In response to Anti join miscalculates row number?  ("Jens Reufsteck" <jens.reufsteck@staufenbiel.de>)
List pgsql-performance
Hello, Jens

On 2011.10.26 13:23, Jens Reufsteck wrote:
> I’ve got a lengthy query, that doesn't finish in reasonable time (i.e.
> 10min+). I suspect, that the query optimizer miscalculates the number of
> rows for part of the query.
>
I'm sorry for the silly question, but have you tried analyze on your
database or at least the tables involved in the query ?


--
Julius Tuskenis
Head of the programming department
UAB nSoft
mob. +37068233050

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bad plan by Planner (Already resolved?)
Next
From: Sören Meyer-Eppler
Date:
Subject: PostgreSQL 9.0.4 blocking in lseek?