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: Thu, 13 Dec 2007 15:19:34 -0600
>>> On Thu, Dec 13, 2007 at 12:12 PM, in message <1197569564(dot)4255(dot)1855(dot)camel(at)ebony(dot)site>, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote: > On Thu, 2007-12-13 at 11:46 -0600, Kevin Grittner wrote: >> If the hint bit changes are written to the WAL ... > > They're not. So one would expect a write-intensive initial vacuum after a PITR-style recovery? What impact would lack of the hint bits have until a vacuum? -Kevin
- Follow-Ups:
- 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
- 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
- Heavy write activity on first vacuum of fresh TOAST data
- Prev by Date: Re: Putting files into fields in a table
- Next by Date: Re: Heavy write activity on first vacuum of fresh TOAST data
- 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 TOAST data
- Indexes: