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

From: Kris Jurka <books(at)ejurka(dot)com>
To: Andres Olarte <olarte(dot)andres(at)gmail(dot)com>
Cc: Kai Ruhl <k(dot)ruhl(at)etamax(dot)de>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JVM crash when select count(*) on large table through JDBC
Date: 2008-02-22 20:33:44
Message-ID: Pine.BSO.4.64.0802221531070.24398@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


On Fri, 22 Feb 2008, Andres Olarte wrote:

> 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?

From a client perspective, select count(*) should be the same no matter
how many rows there are and what types of columns are in the table, so a
test case won't be helpful. If the JVM is just up and dying, that's the
JVM's fault not a pg issue.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andres Olarte 2008-02-22 20:39:54 Re: JVM crash when select count(*) on large table through JDBC
Previous Message Andres Olarte 2008-02-22 20:19:02 Re: JVM crash when select count(*) on large table through JDBC