AW: AW: Plans for solving the VACUUM problem - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: Plans for solving the VACUUM problem
Date
Msg-id 11C1E6749A55D411A9670001FA6879633682E7@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
>     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.

We have a database system here, and not an OLTP helper app.
A database system must support all sorts of mixed usage from simple 
OLTP to OLAP. Imho the usual separation on different servers gives more
headaches than are necessary.

Thus above statement can imho be true for one OLTP application, but not 
for all applications on one db server.

Andreas


pgsql-hackers by date:

Previous
From: Denis Perchine
Date:
Subject: Re: Re: AW: Plans for solving the VACUUM problem
Next
From: Kaare Rasmussen
Date:
Subject: Feedback