Re: [GENERAL] Global Named Prepared Statements

2012-05-21 Thread Cédric Villemain
Le lundi 21 mai 2012 16:08:27, Merlin Moncure a écrit : > On Mon, May 21, 2012 at 8:55 AM, Samba wrote: > > If Stored Procedures are equivalent to prepared statements [ as far as > > preparing the query plan is concerned], then what i'm looking for is > > perhaps a Global Prepared Statements at th

Re: [GENERAL] Global Named Prepared Statements

2012-05-21 Thread Merlin Moncure
On Mon, May 21, 2012 at 8:55 AM, Samba wrote: > If Stored Procedures are equivalent to prepared statements [ as far as > preparing the query plan is concerned], then what i'm looking for is perhaps > a Global Prepared Statements at the client/driver side. > > Specifically, It wold be good if the J

Re: [GENERAL] Global Named Prepared Statements

2012-05-21 Thread Samba
If Stored Procedures are equivalent to prepared statements [ as far as preparing the query plan is concerned], then what i'm looking for is perhaps a Global Prepared Statements at the client/driver side. Specifically, It wold be good if the JDBC driver prepares all the queries for invoking stored

Re: [GENERAL] Global Named Prepared Statements

2012-05-15 Thread Merlin Moncure
On Tue, May 15, 2012 at 1:21 AM, Martijn van Oosterhout wrote: > On Tue, May 15, 2012 at 05:38:27AM +0530, Samba wrote: >> Hi, >> >> Does postgresql support Global Prepared Statements, which are prepared only >> once per server and not per every connection? > > As pointed out, no. > >> Problem wit

Re: [GENERAL] Global Named Prepared Statements

2012-05-14 Thread Martijn van Oosterhout
On Tue, May 15, 2012 at 05:38:27AM +0530, Samba wrote: > Hi, > > Does postgresql support Global Prepared Statements, which are prepared only > once per server and not per every connection? As pointed out, no. > Problem with per-connection prepared statements is that the onus of > preparing those

Re: [GENERAL] Global Named Prepared Statements

2012-05-14 Thread Tom Lane
Samba writes: > Does postgresql support Global Prepared Statements, which are prepared only > once per server and not per every connection? No. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Global Named Prepared Statements

2012-05-14 Thread Samba
Hi, Does postgresql support Global Prepared Statements, which are prepared only once per server and not per every connection? I see a discussion about this in the pgsql-hacker archives but it does not have any conclusion; further, that discussion also deviates a bit from my question by proposing