Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg 8.01 big trouble with LIMIT (bug !?) - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Pg 8.01 big trouble with LIMIT (bug !?)
Date
Msg-id 20050307043057.GA23537@winnie.fuhr.org
Whole thread Raw
In response to Re: Pg 8.01 big trouble with LIMIT (bug !?)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
On Thu, Feb 24, 2005 at 04:20:03PM -0500, Bruce Momjian wrote:
>
> My guess is that you have not ANALYZEd the tables recently and the
> optimizer is making a bad choice.

I think this problem is similar to one a couple of months ago:

http://archives.postgresql.org/pgsql-bugs/2005-01/msg00174.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: getting attribute names, types
Next
From: Greg Stark
Date:
Subject: Re: About Access paths