Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > 9.2 will make this all better. These are exactly the type of case > where you need the "parameterized path" stuff. Yeah, with HEAD on my workstation all of these queries run in less than 0.1 ms. On older versions, I'm seeing times like 100 ms to 150 ms for the slow cases. So in this case, parameterized paths allow an improvement of more than three orders of magnitude. :-) -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
