Greg Stark wrote:
>So for example, I wonder how fast postgres would be if there were a thousand
>connections open, all doing fast one-record index lookups as fast as they can.
>
Yes - some form of "connection reducing" middleare is probably needed at
that point ( unless you have fairly highly spec'ed hardware )
>People are going to say that would just be a poorly designed system, but I
>think they're just not applying much foresight. Reasonably designed systems
>easily need several hundred connections now, and future large systems will
>undoubtedly need thousands.
>
>
I guess the question could be reduced to : whether some form of TP
Monitor functionality should be built into Postgresql? This *might* be a
better approach - as there may be a limit to how much faster a Pg
connection can get. By way of interest I notice that DB2 8.1 has a
connection concentrator in it - probably for the very reason that we
have been discussing...
Maybe there should be a TODO list item in the Pg "Exotic Features" for
connection pooling / concentrating ???
What do people think ?
Mark