All,
Per -performance, we're trying to isolate and reproduce a customer issue
where on 9.2 BINDs get progressively slower (as much as 2000% slower)
over the course of a long test run, in a way they *don't* in 8.4.
So I'm looking for a cause for this. One thing would help is a clearer
understanding of what happens at BIND time for 3-phase queries.
Note that, in this workload, the user is re-parsing the queries
over-and-over rather than using prepared plans properly.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com