Re: JVM crash when select count(*) on large table through 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