Re: [GENERAL] out of memory using Postgres with Spring/Hibernate/Java

2006-03-15 Thread Richard Huxton
maarten roosendaal wrote: Hi, We are currently having a problem that our Postgres DB is throwing an SQL error which states that it's 'out of memory'. What we have is a DB with 1 table that has 3.9 million records. We need to find certain records that are to be processed by a Java App so we do

Re: [GENERAL] out of memory using Postgres with Spring/Hibernate/Java

2006-03-14 Thread chris smith
On 3/15/06, maarten roosendaal <[EMAIL PROTECTED]> wrote: > Hi, > > We are currently having a problem that our Postgres DB > is throwing an SQL error which states that it's 'out > of memory'. > > What we have is a DB with 1 table that has 3.9 million > records. We need to find certain records that

[GENERAL] out of memory using Postgres with Spring/Hibernate/Java

2006-03-14 Thread maarten roosendaal
Hi, We are currently having a problem that our Postgres DB is throwing an SQL error which states that it's 'out of memory'. What we have is a DB with 1 table that has 3.9 million records. We need to find certain records that are to be processed by a Java App so we do a "select id from table wher