Skip site navigation (1) Skip section navigation (2)

Re: pgstat: delayed write of stats file

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pgstat: delayed write of stats file
Date: 2006-04-27 00:06:52
Message-ID: 200604270006.k3R06qw25565@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Patch applied.  Thanks.

---------------------------------------------------------------------------


Magnus Hagander wrote:
> Per some earlier discussion, here is an attempt at implementing a
> "delayed write" of the pgstats file, to decrease the write activity on
> that file.
> 
> It changes so the file is only written once every 5 minutes (changeable
> of course, I just picked something) instead of once every half second.
> It's still written when the stats collector shuts down, just as before.
> And it is now also written on backend request. A backend requests a
> rewrite by simply sending a special stats message. It operates on the
> assumption that the backends aren't actually going to read the
> statistics file very often, compared to how frequent it's written today.
> 
> 
> //Magnus

Content-Description: pgstat_delay.patch

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-04-27 00:34:54
Subject: Re: schema-qualified SET CONSTRAINTS
Previous:From: Bruce MomjianDate: 2006-04-26 23:15:41
Subject: Re: Show tablespace for databases with psql's \l+

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group