pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Simplifying replication
Date: Tue, 26 Oct 2010 10:49:30 -0700
Message-ID: <4CC714AA.20204@agliodbs.com> (raw)
In-Reply-To: <AANLkTimygD1LBeQ-MpJR5XMffM-Gk0fPN2Yw=T3oUKPu@mail.gmail.com>
References: <201010220058.o9M0waa06053@momjian.us>
	<4CC0E465.4000700@agliodbs.com>
	<AANLkTineXrnRAkRV4Cs=rmSo0QkWkFRVYQpj0AWXGn2=@mail.gmail.com>
	<4CC0F10D.3000201@agliodbs.com>
	<AANLkTi=Nz06NGkUAEzJ7r=CMRsiUAJXRsWALqw-jZ62A@mail.gmail.com>
	<4CC1C74E.8080409@agliodbs.com>
	<26273.1287768288@sss.pgh.pa.us>
	<4CC1CB0F.7050006@agliodbs.com>
	<AANLkTimygD1LBeQ-MpJR5XMffM-Gk0fPN2Yw=T3oUKPu@mail.gmail.com>


> What happens if max_wal_size is less than checkpoint_segments?
> Currently a checkpoint tries to leave WAL files which were generated
> from the prior ckpt start to current ckpt end. Because those WAL files
> are required for crash recovery. But we should delete some of them
> according to max_wal_size?

The ideas is that max_wal_size would *replace* checkpoint_segments.  The
checkpoint_segments setting is baffling to most PG DBAs.

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com



view thread (50+ messages)  latest in thread

Message-ID: <4CC714AA.20204@agliodbs.com>
Permalink:  ../4CC714AA.20204@agliodbs.com/
Also on:    postgresql.org/message-id/4CC714AA.20204@agliodbs.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: josh@agliodbs.com, masao.fujii@gmail.com
  Subject: Re: Simplifying replication
  In-Reply-To: <4CC714AA.20204@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox