Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Heavy write activity on first vacuum of fresh TOAST data
- From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
- To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
- Cc: <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Heavy write activity on first vacuum of fresh TOAST data
- Date: Fri, 14 Dec 2007 10:07:41 -0600
>>> On Thu, Dec 13, 2007 at 3:40 PM, in message <1197582010(dot)4255(dot)1912(dot)camel(at)ebony(dot)site>, Simon Riggs <simon(at)2ndquadrant(dot)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
- References:
- Heavy write activity on first vacuum of fresh TOAST data
- From: Kevin Grittner
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Simon Riggs
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Kevin Grittner
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Simon Riggs
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Kevin Grittner
- Re: Heavy write activity on first vacuum of fresh TOAST data
- From: Simon Riggs
- Heavy write activity on first vacuum of fresh TOAST data
- Prev by Date: Re: Heavy write activity on first vacuum of fresh TOASTa
- Next by Date: Re: viewing source code
- Previous by thread: Re: Heavy write activity on first vacuum of fresh TOAST data
- Next by thread: Re: Heavy write activity on first vacuum of fresh TOASTa
- Indexes: