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
from double-write
buffer.
This can ensure very less I/O by any backend.
-Original Message-
From: pgsql-hackers-ow...@postgresql.org
[mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Dan Scales
Sent: Saturday, January 28, 2012 4:02 AM
To: PG Hackers
Subject: [HACKERS] double writes us
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
