table full scan

From: "Khaldoun Ateyeh" <Khaldoun(dot)Ateyeh(at)panoratio(dot)de>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: table full scan
Date: 2006-01-05 09:32:28
Message-ID: 0BD53BBFEDA6B240851F0B40DC7992E7180812@S007DCDE.panoratio.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
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?

Best Regards.

Khaldoun

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-01-05 12:14:22 Re: table full scan
Previous Message TNO 2006-01-05 08:22:48 Crypted password