Re: Cursor-based results: bafflingly slow

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Robin Houston <robin(dot)houston(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Cursor-based results: bafflingly slow
Date: 2009-07-03 13:17:05
Message-ID: 4A4E04D1.5010905@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Robin Houston wrote:

> For example, if I use "limit 100" to simulate the effect of fetching
> the first 100 results:

They're not really equivalent. A portal with a limited fetchsize is more
like DECLARE CURSOR, not LIMIT.

What does the plan look like if you plan it without the LIMIT?

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Robin Houston 2009-07-03 13:40:52 Cursor-based results: bafflingly slow
Previous Message Robin Houston 2009-07-03 13:01:22 Cursor-based results: bafflingly slow