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

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: [JDBC] Re: How embarrassing: optimization of a one-shot query doesn't work
Дата
Msg-id Pine.GSO.4.64.0804011953290.21892@westnet.com
обсуждение исходный текст
Ответ на Re: [JDBC] Re: How embarrassing: optimization of a one-shot query doesn't work  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Ответы Re: [JDBC] Re: How embarrassing: optimization of a one-shot query doesn't work  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-hackers
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@gregsmith.com http://www.gregsmith.com Baltimore, MD

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: New boxes available for QA
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: New boxes available for QA