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

Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Date: 2008-04-02 00:05:12
Message-ID: Pine.GSO.4.64.0804011953290.21892@westnet.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
On Tue, 1 Apr 2008, Guillaume Smet wrote:

> A good answer is probably to plan optional JDBC benchmarks in the
> benchfarm design - not all people want to run Java on their boxes but
> we have servers of our own to do so.

The original pgbench was actually based on an older test named JDBCbench. 
That code is kind of old and buggy at this point.  But with some care and 
cleanup it's possible to benchmark not only relative Java performance with 
it, but you can compare it with pgbench running the same queries on the 
same tables to see how much overhead going through Java is adding.

Original code at http://mmmysql.sourceforge.net/performance/ , there's 
also some improved versions at 
http://developer.mimer.com/features/feature_16.htm

I'm not sure if all of those changes are net positive for PostgreSQL 
though, they weren't last time I played with this.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

pgsql-hackers by date

Next:From: Stephen FrostDate: 2008-04-02 00:20:16
Subject: Re: New boxes available for QA
Previous:From: Greg SmithDate: 2008-04-01 23:53:23
Subject: Re: New boxes available for QA

pgsql-jdbc by date

Next:From: Guillaume SmetDate: 2008-04-02 00:35:17
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Previous:From: Kris JurkaDate: 2008-04-01 17:28:45
Subject: Re: CallableStatement and getUpdateCount

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