| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Jan Wieck <JanWieck(at)Yahoo(dot)com>, Barry Lind <barry(at)xythos(dot)com> |
| Cc: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: AW: Plans for solving the VACUUM problem |
| Date: | 2001-05-22 01:38:54 |
| Message-ID: | 3.0.5.32.20010522093854.00a0cb40@192.228.128.13 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
At 04:41 PM 21-05-2001 -0400, Jan Wieck wrote:
>
> As a rule of thumb, online applications that hold open
> transactions during user interaction are considered to be
> Broken By Design (tm). So I'd slap the programmer/design
> team with - let's use the server box since it doesn't contain
> anything useful.
>
Many web applications use persistent database connections for performance
reasons.
I suppose it's unlikely for webapps to update a row and then sit and wait a
long time for a hit, so it shouldn't affect most of them.
However if long running transactions are to be aborted automatically, it
could possibly cause problems with some apps out there.
Worse if long running transactions are _disconnected_ (not just aborted).
Regards,
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-05-22 04:09:37 | Re: cvs snapshot compile problems |
| Previous Message | Bruce Momjian | 2001-05-22 01:35:11 | Re: New system catalog idea |