From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
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:06:36
Message-ID:
21240.1207029996@sss.pgh.pa.us (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
"Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> writes:
> Another question is how we can be sure it doesn't happen again. The
> easiest way to test this is probably to have a JDBC test testing this
> exact feature in the future benchfarm. Any comment?
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.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Guillaume SmetDate: 2008-04-01 06:45:43Subject : New boxes available for QAPrevious :From : Guillaume SmetDate : 2008-04-01 05:51:11Subject : Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
pgsql-jdbc by date
Next :From: Guillaume SmetDate: 2008-04-01 06:52:55Subject : Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't workPrevious :From : Guillaume SmetDate : 2008-04-01 05:51:11Subject : Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
