Postgres Pro
Downloads
Home   >   mailing lists

Re: strange query plan with LIMIT - Mailing list pgsql-performance

From anthony.shipman@symstream.com
Subject Re: strange query plan with LIMIT
Date
Msg-id 201106081936.32003.anthony.shipman@symstream.com
Whole thread Raw
In response to Re: strange query plan with LIMIT  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: strange query plan with LIMIT  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
Tree view 
On Wednesday 08 June 2011 18:39, Pavel Stehule wrote:
> if you use FOR statement, there should be a problem in using a
> implicit cursor - try to set a GUC cursor_tuple_fraction to 1.0.
Alas this is mammoth replicator, equivalent to PG 8.3 and it doesn't have that
parameter.
--
Anthony Shipman                 | It's caches all the way
Anthony.Shipman@symstream.com   | down.

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Set of related slow queries
Next
From: tv@fuzzy.cz
Date:
Subject: Re: strange query plan with LIMIT