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 Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings