| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Doug McNaught <doug(at)wireboard(dot)com>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, sean-pgsql-hackers(at)chittenden(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Pre-forking backend |
| Date: | 2001-10-15 14:18:31 |
| Message-ID: | 13761.1003155511@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> writes:
> Create a small program that makes a few connections to postgresql, does
> some initialization, preconnects to various DBs (or maybe limited to one DB
> specified on startup), and listens on one port/socket. It might not even
> prefork, just cache connections so first connection is slow, subsequent
> ones are cached along with the user-pass for faster authentication.
> Then your apps can connect to that small program, authenticate, and get the
> relevant connection. Call it a "Listener" if you want ;).
Couple of problems...
(a) where is this outside program going to get authentication
information from?
(b) it seems that not only the authentication exchange, but also all
subsequent data exchange of each connection would have to go through
this additional program. That middleman is going to become a
bottleneck.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Kindness | 2001-10-15 14:32:27 | Re: ecpg - GRANT bug |
| Previous Message | Tom Lane | 2001-10-15 14:10:40 | Re: ecpg - GRANT bug |