On Fri, Jul 07, 2006 at 11:30:35AM +0000, Roman Neuhauser wrote: > > With the LIMIT it might take a different approach, which > > might be worse if you read the whole lot, but better for a limited set. > > A fast-start plan so to speak. > > That looks like a better approach for a cursor.
For a cursor postgres assumes you're going to ask for about 10% of the result, so it does aim for a reasonably fast-start plan. It probably depends on the specifics of the situation how well it works... Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
