Re: ResultSet memory usage

From: Timo Savola <timo(dot)savola(at)codeonline(dot)com>
To: Jens Carlberg <jenca(at)lysator(dot)liu(dot)se>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSet memory usage
Date: 2002-01-12 22:13:15
Message-ID: 1010873595.1144.2.camel@whiz-bang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> If the keys aren't unique enough to avoid the second query getting to
> big, you can use the LIMIT keyword to sorta kinda implement your own
> cursor:

The contents of the table may change from select to select. I think real
cursors work best in this case.

Timo

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Timo Savola 2002-01-12 22:21:33 Re: ResultSet memory usage
Previous Message Tom Lane 2002-01-12 16:28:28 Re: Does pg_dumpall do BLOBs too?