Martijn van Oosterhout wrote:
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.
The analyze is still running (I launched it 30 mins ago), I'll post it as soon
I have it.

Disabling the nested_loop ( set enable_nestloop = false ) the query with the limit
has now the same execution time without the limit.

I don't get why a limit is going to change the query plan and most of all decreasing
the performances.


Regards
Gaetano Mendola

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 9 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedFeb 1, '08 at 11:08a
activeFeb 1, '08 at 5:18p
posts9
users5
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase