Re: Pg 8.01 big trouble with LIMIT (bug !?)

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Hervé Piedvache <herve(at)elma(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pg 8.01 big trouble with LIMIT (bug !?)
Date: 2005-03-07 04:30:57
Message-ID: 20050307043057.GA23537@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2005-03-07 07:57:01 Re: About Access paths
Previous Message Michael Fuhr 2005-03-07 03:50:56 Re: getting attribute names, types