Re: HOT patch - version 15 - Mailing list pgsql-patches

From Greg Smith
Subject Re: HOT patch - version 15
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: HOT patch - version 15  ("Heikki Linnakangas" <[email protected]>)
List pgsql-patches
On Thu, 6 Sep 2007, Heikki Linnakangas wrote:

> I wonder if pruning in bgwriter only is enough to make HOT work
> efficiently. On a very frequently updated page, bgwriter will have to
> work hard to keep up.

One of the goals for how I rebuilt the just-in-time BGW was to try and
make smaller values for bgwriter_delay feasible.  None of the tunables
*should* have to be adjusted if you need to run the bgwriter much more
often to support some new HOT-related activity in there as well; this is
actually my next area I wanted to do a bit more testing on myself.

--
* Greg Smith [email protected] http://www.gregsmith.com Baltimore, MD

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [BUGS] create index concurrently blocks on transactions in other databases
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: tsearch refactorings