Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Prepared Statements vs. pgbouncer


  • From: Paul Lindner <lindner(at)inuus(dot)com>
  • To: Gregory Stark <stark(at)enterprisedb(dot)com>
  • Cc: Paul Lindner <lindner(at)inuus(dot)com>, pgsql-jdbc(at)postgresql(dot)org
  • Subject: Re: Prepared Statements vs. pgbouncer
  • Date: Sat, 29 Sep 2007 07:46:35 -0700
  • Message-id: <20070929144635.GK3140@inuus.com> <text/plain>

On Sat, Sep 29, 2007 at 10:36:33AM +0100, Gregory Stark wrote:
> 
> "Paul Lindner" <lindner(at)inuus(dot)com> writes:
> 
> >   * pgbouncer notices that client A is idle and reassigns backend to 
> >     client B
> 
> What do you mean by "notices"? 

Okay, I wasn't being clear.  In pgbouncer at the END of a commit the
backend will be put into the idle pool.  Please read the following:

https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer

> Prepared statements are only one form of state which can persist beyond a
> transaction end. I don't think you can reassign connections unless you get
> some sort of explicit notice that the client is done with any state it has set
> up. Either the driver supports noticing such a state because there are no
> active references to its handle or the client issues a statement like RESET
> ALL or something equivalent.

Okay.

How do we fix this?  Short term?  Long term?

For this specific case a long term fix might involve
transaction-scoped prepared statements.  Of course that would require
adding this feature on many levels.

Should middleware products track all prepared statements and re-send
those to each backend?  What happens when you have collisions between
names?

Should auto-generated prepared statements use a common hashing method
to insure that we don't recreate the same prepared statement over and
over?

-- 
Paul Lindner        ||||| | | | |  |  |  |   |   |
lindner(at)inuus(dot)com

Attachment: pgpogdIgZfCRx.pgp
Description: PGP signature



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group