On Mon, Dec 10, 2012 at 10:56 AM, Xin Pan wrote:
> However, I still witness large amount of page writes.
> Can anyone tell where are the page writes come from?
Probably not without more details. Things like VACUUM, COPY, and
sequential scans use ring-buffers that are smaller than
shared_buffers,
On 12/10/2012 04:56 PM, Xin Pan wrote:
Assumption: I have enough memory to cache all the database pages.
Goal:
Master never write pages. Slave replays logs from master and writes
pages.
Benefits:
Reduce the page IO overhead at master, save money in EC2 cloud.
I have suggested something simila
Assumption: I have enough memory to cache all the database pages.
Goal:
Master never write pages. Slave replays logs from master and writes pages.
Benefits:
Reduce the page IO overhead at master, save money in EC2 cloud.
Question:
Can you give me some comments on this idea?
And I cannot turn of p
