On 5/28/07, Dave Cramer [EMAIL PROTECTED] wrote:
Since PITR has to enable archiving does this not increase the amount
of disk I/O required ?
I've set up warm standbys on a few servers (some of them quite
busy!)...the additional load is virtually unmeasurable. I usually
don't copy the files
Since PITR has to enable archiving does this not increase the amount
of disk I/O required ?
Dave
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Dave Cramer [EMAIL PROTECTED] wrote:
Since PITR has to enable archiving does this not increase the amount
of disk I/O required ?
It does increase the required amount of I/O.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
am Mon, dem 28.05.2007, um 8:45:38 -0400 mailte Dave Cramer folgendes:
Since PITR has to enable archiving does this not increase the amount
of disk I/O required ?
Yes. But you can use a different hard drive for this log.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150,
Dave Cramer wrote:
Since PITR has to enable archiving does this not increase the amount of
disk I/O required ?
There's no difference in normal DML operations, but some bulk operations
like CREATE INDEX that don't otherwise generate WAL, need to be WAL
logged when archiving is enabled.
--
Heikki,
Don't the archived logs have to be copied as well as the regular WAL
logs get recycled ?
Dave
On 28-May-07, at 12:31 PM, Heikki Linnakangas wrote:
Dave Cramer wrote:
Since PITR has to enable archiving does this not increase the
amount of disk I/O required ?
There's no
Dave, et al,
* Dave Cramer ([EMAIL PROTECTED]) wrote:
Don't the archived logs have to be copied as well as the regular WAL
logs get recycled ?
Yes, but I'd expect at the point they're being copied off to some other
store (probably a seperate disk, or even over the network to another
system,
On Mon, 2007-05-28 at 08:45 -0400, Dave Cramer wrote:
Since PITR has to enable archiving does this not increase the amount
of disk I/O required ?
As Heikki says, some operations need logging when PITR is on; these are
now documented in the performance tips section of the latest dev docs: