Re: Is full_page_writes=off safe in conjunction with PITR?

From: markir(at)paradise(dot)net(dot)nz
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Is full_page_writes=off safe in conjunction with PITR?
Date: 2006-04-14 23:04:30
Message-ID: 1145055870.44402a7e86c9b@www.paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> I fear we still have to disable full_page_writes (force it ON) if
> XLogArchivingActive is on. Comments?

Yeah - if you are enabling PITR, then you care about safety and integrity, so it
makes sense (well, to me anyway).

Cheers

Mark

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2006-04-15 02:48:49 Re: Possible race in UnlockBuffers() and UnpinBuffer()
Previous Message Tom Lane 2006-04-14 22:37:19 Re: two-argument aggregates and SQL 2003