From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | Greg Stark <gsstark(at)mit(dot)edu> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Anyone working on better transaction locking? |
Date: | 2003-04-12 22:45:30 |
Message-ID: | 3E98970A.5000101@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Greg Stark wrote:
>Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
>
>
>
>>But database is not webserver. It is not suppose to handle tons of concurrent
>>requests. That is a fundamental difference.
>>
>>
>
>And in one fell swoop you've dismissed the entire OLTP database industry.
>
>Have you ever called a travel agent and had him or her look up a fare in the
>airline database within seconds? Ever placed an order over the telephone?
>Ever used a busy database-backed web site?
>
>
That situation is usually handled by means of a TP Monitor that keeps
open database connections ( e.g, CICS + DB2 ).
I think there is some confusion between "many concurrent connections +
short transactions" and "many connect / disconnect + short transactions"
in some of this discussion.
OLTP systems typically fall into the first case - perhaps because their
db products do not have fast connect / disconnect :-). Postgresql plus
some suitable middleware (e.g Php) will handle this configuration *with*
its current transaction model.
I think you are actually talking about the connect / disconnect speed
rather than the *transaction* model per se.
best wishes
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2003-04-12 23:21:36 | Re: Anyone working on better transaction locking? |
Previous Message | Jan Wieck | 2003-04-12 21:27:32 | Re: Backpatch FK changes to 7.3 and 7.2? |