Skip site navigation (1) Skip section navigation (2)

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

From: "Andres Olarte" <olarte(dot)andres(at)gmail(dot)com>
To: "Kris Jurka" <books(at)ejurka(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:39:54
Message-ID: 3fccaa690802221239t4763c8e8y7ad83e2cd1cfb2a5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
I know it's the same to count 1 o 20M rows, but it takes much longer
to count 20M.  I really don't know much about the internal of the
driver, but maybe some kind of time out?

On Fri, Feb 22, 2008 at 2:33 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:
>
>  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

pgsql-jdbc by date

Next:From: Dave CramerDate: 2008-02-22 21:13:18
Subject: Re: JVM crash when select count(*) on large table through JDBC
Previous:From: Kris JurkaDate: 2008-02-22 20:33:44
Subject: Re: JVM crash when select count(*) on large table through JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group