From: | "Andres Olarte" <olarte(dot)andres(at)gmail(dot)com> |
---|---|
To: | "Kai Ruhl" <k(dot)ruhl(at)etamax(dot)de> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JVM crash when select count(*) on large table through JDBC |
Date: | 2008-02-22 20:19:02 |
Message-ID: | 3fccaa690802221219u7c7fd66bk4cc152cb8819e26b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(at)fastcrypt(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2008-02-22 20:33:44 | Re: JVM crash when select count(*) on large table through JDBC |
Previous Message | Dave Cramer | 2008-02-22 19:30:38 | Re: JVM crash when select count(*) on large table through JDBC |