Re: strange query plan with LIMIT

From: anthony(dot)shipman(at)symstream(dot)com
To: pgsql-performance(at)postgresql(dot)org
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Claudio Freire <klaussfreire(at)gmail(dot)com>
Subject: Re: strange query plan with LIMIT
Date: 2011-06-08 09:36:31
Message-ID: 201106081936.32003.anthony.shipman@symstream.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(dot)Shipman(at)symstream(dot)com | down.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2011-06-08 09:47:43 Re: strange query plan with LIMIT
Previous Message Craig Ringer 2011-06-08 09:20:46 Re: Set of related slow queries