From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | jd(at)commandprompt(dot)com |
Cc: | julian(at)avbrief(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgpool simple feature request |
Date: | 2005-02-06 13:19:57 |
Message-ID: | 20050206.221957.102577936.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Hello,
>
> Command Prompt develops a lot of web based applications.
> One of the problems with the web is you can't really
> pre determine a lot of tasks because of the statelessness.
>
> It would be nice if you could tell pgpool to perform certain
> queries on initialization of a new connection. This would
> allow web based applications to take advantange of several
> nice features including:
>
> cursors for more than just the single session
> global variables
> preloaded indexes for performance in ram
Yes, I thought about that too. Probably we need two kinds of
initializations:
1) initilization for each new connection (as you requested)
2) initilization for each new client connection
I think pgpool could do both of them since it has already done series
of queries in closing client connections.
--
Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-02-06 13:23:48 | Re: Help with sorting (ie. ORDER BY expression) |
Previous Message | Roman Neuhauser | 2005-02-06 13:02:53 | Re: pgpool 2.5b2 released |