From: | Adrian Maier <am(at)fx(dot)ro> |
---|---|
To: | Seun Osewa <seunosewa(at)inaira(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Possible Commit Syntax Change for Improved TPS |
Date: | 2003-10-08 08:43:57 |
Message-ID: | 3F83CE4D.4090902@fx.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)fx(dot)ro)
From | Date | Subject | |
---|---|---|---|
Next Message | Manfred Koizar | 2003-10-08 09:31:30 | Re: [HACKERS] Cannot dump/restore text value \N |
Previous Message | Allie Micka | 2003-10-08 06:54:23 | plpgsql overloading bug in 7.3.2 on OS X |