Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Point in Time Recovery

From: "Simon(at)2ndquadrant(dot)com" <simon(at)2ndquadrant(dot)com>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Klaus Naumann" <kn(at)mgnet(dot)de>, <markw(at)osdl(dot)org>,<pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-08-14 00:50:22
Message-ID: NOEFLCFHBPDAFHEIPGBOCEHDCCAA.simon@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-patches
> Tom Lane wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > Now, if you say people will rarely turn archiving on/off, then one
> > > parameter seems to make more sense.
> >
> > I really can't envision a situation where people would do that.  If you
> > need PITR at all then you need it 24x7.
>
I agree. The second parameter is only there to clarify the intent.

8.0 does introduce two good reasons to turn it on/off, however:
- index build speedups
- COPY speedups

I would opt to make enabling/disabling archive_command require a postmaster
restart. That way there would be no capability to take advantage of the
incentive to turn it on/off.

For TODO:

It would be my intention (in 8.1) to make those available via switches e.g.
NOT LOGGED options on CREATE INDEX and COPY, to allow users to take
advantage of the no logging optimization without turning off PITR system
wide. (Just as this is possible in Oracle and Teradata).

I would also aim to make the first Insert Select into an empty table not
logged (optionally). This is an important optimization for Oracle, teradata
and DB2 (which uses NOT LOGGED INITIALLY).

Best Regards, Simon Riggs


In response to

Responses

pgsql-hackers by date

Next:From: Simon@2ndquadrant.comDate: 2004-08-14 00:50:23
Subject: PITR on Windows?
Previous:From: Simon@2ndquadrant.comDate: 2004-08-14 00:44:57
Subject: Re: Development Schedule Page

pgsql-admin by date

Next:From: Tom LaneDate: 2004-08-14 02:29:09
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Tom LaneDate: 2004-08-13 20:24:54
Subject: Re: Pg_dump does not include database search path in backup file

pgsql-patches by date

Next:From: Tom LaneDate: 2004-08-14 02:29:09
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Andreas SeltenreichDate: 2004-08-14 00:46:35
Subject: Minor psql reference fix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group