Re: Cursor-based results: bafflingly slow - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Cursor-based results: bafflingly slow
Date
Msg-id 4A4E04D1.5010905@opencloud.com
Whole thread Raw
In response to Cursor-based results: bafflingly slow  (Robin Houston <robin.houston@gmail.com>)
List 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


pgsql-jdbc by date:

Previous
From: Robin Houston
Date:
Subject: Cursor-based results: bafflingly slow
Next
From: Robin Houston
Date:
Subject: Cursor-based results: bafflingly slow