From:
"Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"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-01 06:52:55
Message-ID:
1d4e0c10803312352x7e58e971k6a9ea44497954f5d@mail.gmail.com (view raw or flat )
Thread:
2008-03-31 23:26:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 00:46:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2008-04-01 01:51:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 02:12:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2008-04-01 05:35:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 05:51:11 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2008-04-01 06:06:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 06:52:55 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2008-04-02 00:05:12 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-04-02 00:35:17 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2008-04-02 00:53:23 from Dave Cramer <pg(at)fastcrypt(dot)com>
2008-04-02 01:04:04 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2008-04-10 09:47:36 from Thomas Burdairon <tburdairon(at)entelience(dot)com>
2008-04-10 10:44:20 from Dave Cramer <pg(at)fastcrypt(dot)com>
2008-04-10 12:33:39 from Thomas Burdairon <tburdairon(at)entelience(dot)com>
2008-05-29 03:13:12 from "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
2008-05-29 03:19:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-05-29 03:22:34 from "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
2008-04-01 10:25:14 from Michael Paesold <mpaesold(at)gmx(dot)at>
2008-04-01 11:14:34 from Dave Cramer <pg(at)fastcrypt(dot)com>
2008-04-01 14:06:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-04-01 14:26:52 from Dave Cramer <pg(at)fastcrypt(dot)com>
2008-04-01 14:43:58 from PFC <lists(at)peufeu(dot)com>
2008-04-01 14:21:34 from Michael Paesold <mpaesold(at)gmx(dot)at>
2008-05-23 10:20:45 from Dave Cramer <pg(at)fastcrypt(dot)com>
2008-05-23 13:20:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-05-28 12:25:14 from Dave Cramer <pg(at)fastcrypt(dot)com>
2008-05-28 14:24:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers pgsql-jdbc
On Tue, Apr 1, 2008 at 8:06 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Yeah, the lack of any formal testing of the extended-Query protocol
> is a real problem. I'm not sure of a good fix, but it bears some
> thinking about. Not only do we not have an automated way to notice
> if we broke functionality, but we don't really notice for either
> extended or basic protocol if we hurt performance.
I just posted something to -hackers about the availability of boxes
for QA purposes. It doesn't solve the problem by itself though.
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. Andrew?
--
Guillaume
In response to
Responses
pgsql-hackers by date
Next :From: Mathias HasselmannDate: 2008-04-01 07:35:56Subject : Re: [HACKERS] Avahi support for PostgresqlPrevious :From : Guillaume SmetDate : 2008-04-01 06:45:43Subject : New boxes available for QA
pgsql-jdbc by date
Next :From: Kris JurkaDate: 2008-04-01 07:22:24Subject : Re: Deadlock while using getNotifications() and Statement.executeQuery()Previous :From : Tom LaneDate : 2008-04-01 06:06:36Subject : Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
