Re: pgpool simple feature request

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

In response to

Responses

Browse pgsql-general by date

  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