Re: table full scan

From: Kris Jurka <books(at)ejurka(dot)com>
To: Khaldoun Ateyeh <Khaldoun(dot)Ateyeh(at)panoratio(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: table full scan
Date: 2006-01-05 12:14:22
Message-ID: Pine.BSO.4.61.0601050713560.9579@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 5 Jan 2006, Khaldoun Ateyeh wrote:

> I am using jdbc to full scan a huge table (over 11 million records).
> Unfortunately, I get an OutOfMemoryError exception. Is there any way to
> tell postgre not to try to load the whole table at once?
>

http://jdbc.postgresql.org/documentation/81/query.html#query-with-cursor

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Roland Walter 2006-01-05 12:15:17 Re: table full scan
Previous Message Khaldoun Ateyeh 2006-01-05 09:32:28 table full scan