View Single Post

   
  #4 (permalink)  
Old 04-19-2008, 10:52 AM
Heikki Linnakangas
 
Posts: n/a
Default Re: PITR performance costs

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

Reply With Quote