Re: Question for the developers. - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Question for the developers.
Date
Msg-id 3FAFB55A.2020501@Yahoo.com
Whole thread Raw
In response to Question for the developers.  (suchindra@linuxlabs.com)
List pgsql-hackers
suchindra@linuxlabs.com wrote:

> Hi,
> 
>  I am Suchindra Katageri and am working as a Software Engineer at
>  Linuxlabs, Atlanta, GA.
>  
>  I am presently working on developing libraries to make postgresql
>  run on a cluster. I was wondering if it was possible to force Database
>  writes to stable storage, without messing up with the postgres code.
>  e.g. force the PostgreSQL to write to stable storage after an INSERT
>  command.

I don't see how that would help you very far.

PostgreSQL holds disk buffers in a shared memory cache. And unless you 
modify that cache, it would not read from the file again if it thinks it 
knows the content already. How do you intend to remove pages from that 
shared buffer cache at the time, another cluster member modifies the 
same logical page?


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Experimental patch for inter-page delay in VACUUM
Next
From: "scott.marlowe"
Date:
Subject: Re: Performance features the 4th