View Single Post

   
  #9 (permalink)  
Old 04-19-2008, 10:43 AM
Kevin Grittner
 
Posts: n/a
Default Re: Heavy write activity on first vacuum of freshTOAST data

>>> On Thu, Dec 13, 2007 at 3:40 PM, in message
<1197582010.4255.1912.camel@ebony.site>, Simon Riggs <simon@2ndquadrant.com>
wrote:
> On Thu, 2007-12-13 at 15:19 -0600, Kevin Grittner wrote:


>> So one would expect a write-intensive initial vacuum after a
>> PITR-style recovery?


> An interesting issue when running with full_page_writes off.


I'm curious. How does the full_page_writes setting affect this?

-Kevin




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote