Re: Possible Commit Syntax Change for Improved TPS

Seun Osewa wrote:
> I observed that in in many applications there are some transactions
> that are more critical than others.  I may have the same database
> instance managing website visitor accounting and financial
> transactions.  I could tolerate the loss of a few transactions whose
> only job is to tell me a user has clicked a page on my website but
> would not dare risk this for any of the "real" financials work my
> web-based app is doing.

It is possible to split the data over 2 database clusters:
one which contains "important" data (this cluster will be configured 
with fsync enabled),   and a second one that contains the less
important data (configured with fsync=off for speed reasons).



Cheers,

Adrian Maier
(am@fx.ro)