Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 22 Feb 2008 15:33:44 -0500 (EST)
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
- Follow-Ups:
- Re: JVM crash when select count(*) on large table through JDBC
- From: Andres Olarte
- Re: JVM crash when select count(*) on large table through JDBC
- References:
- JVM crash when select count(*) on large table through JDBC
- From: Kai Ruhl
- Re: JVM crash when select count(*) on large table through JDBC
- From: Dave Cramer
- Re: JVM crash when select count(*) on large table through JDBC
- From: Andres Olarte
- JVM crash when select count(*) on large table through JDBC
- Prev by Date: Re: JVM crash when select count(*) on large table through JDBC
- Next by Date: Re: JVM crash when select count(*) on large table through JDBC
- Previous by thread: Re: JVM crash when select count(*) on large table through JDBC
- Next by thread: Re: JVM crash when select count(*) on large table through JDBC
- Indexes: