PGStream.ReceiveTupleV3 and Out of Memory
От | digifork |
---|---|
Тема | PGStream.ReceiveTupleV3 and Out of Memory |
Дата | |
Msg-id | BANLkTikHyO3ineSui4KosP5mn=vPPJtKNg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: PGStream.ReceiveTupleV3 and Out of Memory
Re: PGStream.ReceiveTupleV3 and Out of Memory |
Список | pgsql-jdbc |
Hello All! I have a question that I hope someone can help me with. I have a very large query against a PostgreSQL 8.2 database using an iBatis 2.3.4 RowHandler, postgresql-8.2 JDBC4 driver, and a 32-bit Java 1.6 JVM. The reason why we use the RowHandler is because we know this is a big query and want to handle it a row at a time. When I start the query, it takes some time to return the first row. When the query is about to return the first row, there is a giant spike in heap memory use and the the JVM runs out of memory. I was able to snapshot the heap before it crashed. The culprit seems to be this call: 97.4% - 632 MB - 17,776,474 alloc. org.postgresql.core.PGStream.ReceiveTupleV3 I have analyzed the database and we have no rows that exceed 2K in size; so I know the problem is not related to returning a giant single row. Does anyone have any ideas why ReceiveTupleV3 is returning so much data? Thank you! -Dan
В списке pgsql-jdbc по дате отправления: