Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting performance

Connecting performance

From
马庆
Date:

Dear :

         These days, I come across a problem that I can’t solve i , so I ask U for help.

         Problem Description:

                   I use RedHat AS 4 + PostgreSQL 8.1 as our server. As long as the server program starts, it’ll immediately open 10~20 connects to the DB to handle the request.

                   But my college ask me “Do you know Oracle, it has connect pool to queue the request, so you needn’t open so much connects. Does PostgreSQL has such function?”

 

         Does anybody know something about it? Please tell me.

Thanks

                                                                                                                                                                                 MARK

Re: Connecting performance

From
mike
Date:
Sounds like pgpool. http://pgpool.projects.postgresql.org/

On Thu, 2006-12-21 at 12:01 +0800, 马庆 wrote:
> Dear :
>
>          These days, I come across a problem that I can’t solve i , so
> I ask U for help.
>
>          Problem Description:
>
>                    I use RedHat AS 4 + PostgreSQL 8.1 as our server.
> As long as the server program starts, it’ll immediately open 10~20
> connects to the DB to handle the request.
>
>                    But my college ask me “Do you know Oracle, it has
> connect pool to queue the request, so you needn’t open so much
> connects. Does PostgreSQL has such function?”
>
>
>
>          Does anybody know something about it? Please tell me.
>
> Thanks
>
>
> MARK
>
>