memory « postgresql « Java Database Q&A





1. Out Of Memory using Postgres in Java    stackoverflow.com

Well, we have a web app, running over JBoss and we're having an "OutOfMemory" error when trying to insert a lot of rows in several tables of a postgres DB. This is ...

2. jdbc + large postgresql query give out of memory    stackoverflow.com

I'm trying to execute a postgresql query which returns a large result:

connection.setAutoCommit(false);
st = connection.createStatement(
  ResultSet.CONCUR_READ_ONLY,
  ResultSet.TYPE_FORWARD_ONLY
);
st.setFetchSize(100);
logMemory();
System.out.println("start query ");
rs = st.executeQuery(queryString);
System.out.println("done query ");
logMemory();
but this uses a lot of memory:
Free memory; ...

3. out of memory exception in RMI    stackoverflow.com

Dear all, I am using java rmi for my program, from client side i am calling my interface method by passing single argument. Using this argument interface runs a query and returns ...

4. Memory cache options for postgres and java    stackoverflow.com

Running a last db server jersey applications and I need to start thinking about memory caching. The majority of the db commands are only updated once a day. There is an opportinity ...

5. Memory usage of PostgreSQL connection is increasing in execution    stackoverflow.com

I have a webcrawler thar uses a connection pool to connect to database and insert pages. I saw that the memory usage is increasing while the program executes. I guess that I ...

6. org.postgresql.util.PSQLException: ERROR: out of shared memory    stackoverflow.com

I am calling a function having more than 200 DROP Table Statements using JAVA and I am getting org.postgresql.util.PSQLException: ERROR: out of shared memory. What approach should i follow in order to ...