Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Dave Cramer <pg(at)fastcrypt(dot)com>
Cc:
Michael Paesold <mpaesold(at)gmx(dot)at>, pgsql-hackers(at)postgreSQL(dot)org,
pgsql-jdbc(at)postgreSQL(dot)org
Subject:
Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Date:
2008-04-01 14:06:01
Message-ID:
1452.1207058761@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
Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> Was the driver ever changed to take advantage of the above strategy?
Well, it's automatic as long as you use the unnamed statement. About
all that might need to be done on the client side is to use unnamed
statements more often in preference to named ones, and I believe that
something like that did get done in JDBC.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Morris GoldsteinDate: 2008-04-01 14:12:15Subject : Re: Can Postgres 8.x start if some disks containing tablespaces are not mounted?Previous :From : Andrew DunstanDate : 2008-04-01 13:59:35Subject : Re: build multiple indexes in single table pass?
pgsql-jdbc by date
Next :From: Michael PaesoldDate: 2008-04-01 14:21:34Subject : Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't workPrevious :From : Dave CramerDate : 2008-04-01 11:14:34Subject : Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
