sync and cache

From: Medi Montaseri <medi(at)cybershell(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: sync and cache
Date: 2002-04-02 05:28:27
Message-ID: 3CA9417B.1394E6C9@cybershell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have silly HA environment where box A and B are using the same
storage.
Box B will take over when Box A dies.

I'm guaranteed that as long as the data gets to the physical disk, data
is preserved.
(I know better, but that is not my problem). At any rate, I'm interested
in minimizing
the amount of data box A is caching as my env is relatively quiet.

My question is, is there anyway to put the backend on a 'Sync" write
through mode.
I read about -F, but that is the oposite of what I want.

Not only I want to sync, but I want to do with every write (or close to
it)

Could I use NOTIFY or triggers, or they are too high up in the food
chain....
Perhaps I need to go after the source code and recompile...
What is the default algorithm? ie when/how does PG decides to write its
buffers.

Thanks

--
-------------------------------------------------------------------------
Medi Montaseri medi(at)CyberShell(dot)com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-04-02 06:54:45 Re: Errors when running vacuumdb...
Previous Message Dominic J. Eidson 2002-04-02 03:41:48 Errors when running vacuumdb...