Re: Allow pooled connections to list all prepared queries

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: David Brown <dave(at)spoonguard(dot)org>, PostgreSQL Global Development Group <pgsql-patches(at)postgresql(dot)org>, Charlie Peck <charliep(at)cs(dot)earlham(dot)edu>
Subject: Re: Allow pooled connections to list all prepared queries
Date: 2004-12-26 03:11:00
Message-ID: 41CE2BC4.4040000@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

> I don't see this as all that helpful for a client interface that does the
> preparation itself. Possibly it could be used for libpq, but you
> mentioned DBI which should already know what it has or has not prepared.
> The idea of adding a network round trip to detect a prepared statement
> seems like a performance loss, not a gain. If this is just to avoid
> repreparing the same statement then perhaps something like PREPARE OR
> REPLACE would be more useful.

Yes, PREPARE OR REPLACE was the other thing I thought would be useful.
However, in my example that still means preparing everytime, wasting the
benefits.

You could have:

PREPARE IF NOT EXISTS

:P

Chris

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-12-26 18:32:58 MSVC compile errors
Previous Message Christopher Kings-Lynne 2004-12-26 03:07:55 Re: Allow pooled connections to list all prepared queries