What happens at BIND time? - Mailing list pgsql-hackers

From Josh Berkus
Subject What happens at BIND time?
Date
Msg-id 5217DD6D.60804@agliodbs.com
Whole thread Raw
Responses Re: What happens at BIND time?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL PERFORM with CTE
Next
From: Tom Lane
Date:
Subject: Re: What happens at BIND time?