sync and cache
От | Medi Montaseri |
---|---|
Тема | sync and cache |
Дата | |
Msg-id | 3CA9417B.1394E6C9@cybershell.com обсуждение исходный текст |
Список | 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@CyberShell.com Unix Distributed Systems Engineer HTTP://www.CyberShell.com CyberShell Engineering -------------------------------------------------------------------------
В списке pgsql-general по дате отправления: