Re: Heavy write activity on first vacuum of fresh TOAST data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>> On Thu, Dec 13, 2007 at  3:40 PM, in message
<1197582010.4255.1912.camel@xxxxxxxxxx>, Simon Riggs <simon@xxxxxxxxxxxxxxx>
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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux