Re: JVM crash when select count(*) on large table through JDBC

Just did a quick test with synthetic data (20M rows 3 columns: serial,
timestamp, and text).  And it worked ok both on Java (with driver
postgresql-8.1-407.jdbc3.jar)  and PgAdmin.

Perhaps you could try to build a test case to expose the problem?

On Fri, Feb 22, 2008 at 1:30 PM, Dave Cramer <pg@fastcrypt.com> wrote:
>
>  On 22-Feb-08, at 11:25 AM, Kai Ruhl wrote:
>
>  > Hello,
>  >
>  > I have a curious problem, which I would like to know whether somebody
>  > can reproduce this: From a JVM using JDBC, I issue
>  >
>  >       select count(*) from big_table
>  >
>  > where big table has more than 20 million entries (timestamps and
>  > numbers). Upon PreparedStatement.executeQuery(), the VM quits, without
>  > any message.
>  >
>  It's my understanding that regardless of what a java program is doing
>  (aside from calling exit, or jni code) , it should never crash.
>
>  I would say there is a bug in your jvm.
>
>
>
>  ---------------------------(end of broadcast)---------------------------
>  TIP 6: explain analyze is your friend
>