Re: Core team statement on replication in PostgreSQL

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Core team statement on replication in PostgreSQL
Date: 2008-07-15 22:56:31
Message-ID: 200807152256.m6FMuVa21901@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > Alvaro Herrera wrote:
> > > Bruce Momjian wrote:
> > >
> > > > Added to TODO:
> > > >
> > > > o Reduce PITR WAL file size by removing full page writes and
> > > > by removing trailing bytes to improve compression
> > >
> > > If we remove full page writes, how does hint bit setting get propagated
> > > to the slave?
> >
> > We would remove full page writes that are needed for crash recovery, but
> > perhaps keep other full pages.
>
> How do you tell which is which?

The WAL format would have to be modified to indicate which entries can
be discarded.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Robert Treat 2008-07-16 00:26:02 Re: [pgsql-advocacy] Pg booth staffing at OSCON
Previous Message Alvaro Herrera 2008-07-15 22:32:08 Re: Core team statement on replication in PostgreSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-07-15 23:15:14 Re: Lookup penalty for VARIADIC patch
Previous Message Alvaro Herrera 2008-07-15 22:32:08 Re: Core team statement on replication in PostgreSQL