n
- Original Message -
From: "Amit Kapila"
To: "Dan Scales" , "PG Hackers"
Sent: Tuesday, February 7, 2012 1:08:49 AM
Subject: Re: [HACKERS] double writes using "double-write buffer" approach [WIP]
>> I think it is a good idea, and can h
m: "Amit Kapila"
To: "Dan Scales" , "PG Hackers"
Sent: Tuesday, February 7, 2012 1:08:49 AM
Subject: Re: [HACKERS] double writes using "double-write buffer" approach [WIP]
>> I think it is a good idea, and can help double-writes perform better in the
On 02/07/2012 12:09 AM, Dan Scales wrote:
So, yes, good point -- double writes cannot replace the functionality of
full_page_writes for base backup. If double writes were in use, they might be
automatically switched over to full page writes for the duration of the base
backup. And the double
>> I think it is a good idea, and can help double-writes perform better in the
>> case of lots of backend evictions.
I don't understand this point, because from the data in your mail, it
appears that when shared buffers are less means when more evictions can happen,
the performance is less.
ot;PG Hackers"
Sent: Monday, February 6, 2012 3:08:15 AM
Subject: Re: [HACKERS] double writes using "double-write buffer" approach [WIP]
On Sat, Jan 28, 2012 at 7:31 AM, Dan Scales wrote:
> Let me know if you have any thoughts/comments, etc. The patch is
> enclosed, and the REA
On Sat, Jan 28, 2012 at 7:31 AM, Dan Scales wrote:
> Let me know if you have any thoughts/comments, etc. The patch is
> enclosed, and the README.doublewrites is updated a fair bit.
ISTM that the double-write can prevent torn-pages in neither double-write file
nor data file in *base backup*. Beca
On Sun, Feb 5, 2012 at 4:17 PM, Dan Scales wrote:
> Thanks for the detailed followup. I do see how Postgres is tuned for
> having a bunch of memory available that is not in shared_buffers, both
> for the OS buffer cache and other memory allocations. However, Postgres
> seems to run fine in many
the double-write files can be stored on.
Thanks,
Dan
- Original Message -
From: "Robert Haas"
To: "Dan Scales"
Cc: "PG Hackers"
Sent: Friday, February 3, 2012 1:48:54 PM
Subject: Re: [HACKERS] double writes using "double-write buffer" app
On Fri, Feb 3, 2012 at 3:14 PM, Dan Scales wrote:
> Thanks for the feedback! I think you make a good point about the small size
> of dirty data in the OS cache. I think what you can say about this
> double-write patch is that it will work not work well for configurations that
> have a small P
an
- Original Message -
From: "Robert Haas"
To: "Dan Scales"
Cc: "PG Hackers"
Sent: Thursday, February 2, 2012 7:19:47 AM
Subject: Re: [HACKERS] double writes using "double-write buffer" approach [WIP]
On Fri, Jan 27, 2012 at 5:31 PM, Dan Scales
On Fri, Jan 27, 2012 at 5:31 PM, Dan Scales wrote:
> I've been prototyping the double-write buffer idea that Heikki and Simon
> had proposed (as an alternative to a previous patch that only batched up
> writes by the checkpointer). I think it is a good idea, and can help
> double-writes perform b
11 matches
Mail list logo
