From: | Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net> |
---|---|
To: | postgres jdbc <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | setFetchSize() not working |
Date: | 2004-10-10 14:42:36 |
Message-ID: | 41694A5C.3050402@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I'm using the 7.3.3 backend, and the JDBC 8.0dev jdbc driver
(pgdev.306.jdbc3.jar).
I'm calling PreparedStatement.setFetchSize(32), on a table fetching 32KB
BYTEA records, and I'm blowing out memory on the executeQuery() call
of the prepared statement.
PreparedStatement.getFetchDirection reports 1000, which is
ResultSet.FETCH_FORWARD.
Any clues?
Here's the trace catching the driver red-handed with all the memory:
SITES BEGIN (ordered by live bytes) Sun Oct 10 09:55:56 2004
percent live alloc'ed stack class
rank self accum bytes objs bytes objs trace name
1 80.92% 80.92% 55023456 578 80423168 1051 62286 [B
TRACE 62286:
org.postgresql.core.PGStream.Receive(PGStream.java:410)
org.postgresql.core.PGStream.ReceiveTupleV2(PGStream.java:395)
org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:337)
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:251)
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:159)
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:346)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:294)
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:209)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
From | Date | Subject | |
---|---|---|---|
Next Message | Ulrich Meis | 2004-10-10 16:04:53 | proposal concerning the bug about updating a table named "two words" |
Previous Message | Dave Cramer | 2004-10-09 19:06:12 | Re: New jdbc website |