Prepared queries - Mailing list pgsql-general

From Cyril VELTER
Subject Prepared queries
Date
Msg-id 054101c3f0e3$23d7e620$f901a8c0@cvfixe
Whole thread Raw
Responses Re: Prepared queries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm converting an application to use the V3 protocol features in the 7.4
libpq. As I need to make a design choice regarding the use of prepared
statements, I'm wondering what ressources does a prepared statement use on
the server ? If I need to create several hundred in each backend, is there a
big memory overhead ? What's the time spent by the backend to find one
prepared statement into a list of several hundreds of them ?

    TIA

    cyril


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: createdb feature request
Next
From: Richard Huxton
Date:
Subject: Re: createdb feature request