Horton

Re: AW: Plans for solving the VACUUM problem

Lincoln Yeoh <lyeoh@pop.jaring.my>

View thread View on postgr.es
From: Lincoln Yeoh <lyeoh@pop.jaring.my>
To: Jan Wieck <JanWieck@Yahoo.com>, Barry Lind <barry@xythos.com>
Cc: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>, pgsql-hackers@postgresql.org
Date: 2001-05-22T01:38:54Z
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.