Postgres Pro
Downloads
Home   >   mailing lists

Re: Limit changes query plan - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Limit changes query plan
Date
Msg-id 20080201111609.GB14265@svana.org
Whole thread Raw
In response to Limit changes query plan  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: Limit changes query plan  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
Tree view 
On Fri, Feb 01, 2008 at 12:08:56PM +0100, Gaetano Mendola wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
> I'm using 8.2.6 and I'm observing a trange behaviour using
> offset and limits.

Please post EXPLAIN ANALYZE output so we can see what's actually taking
the time.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Limit changes query plan
Next
From: Gaetano Mendola
Date:
Subject: Re: Limit changes query plan