Josh Berkus wrote:
This might be worth mentioning, since it can be quite a big difference
in the right circumstances, and it helps a bit with the scalability
problem of the recovery. Should mention that it only helps with
full_pages_writes=on. One more reason to not gamble with data integrity
;-).
Does this mean that recovery from logs with full_page_writes will be faster
than recovery from logs without them?
In general, yes. Depends a lot on how randomly the data in the WAL is
distributed, speed of reading from WAL etc.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend