Re: Moving pgstat.stat and pgstat.tmp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving pgstat.stat and pgstat.tmp
Date: 2007-12-04 00:10:36
Message-ID: 16415.1196727036@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Erik Jones <erik(at)myemma(dot)com> writes:
> 8.2.5 on Solaris 10. Before we upgraded to 8.2.4 it was doing about
> 65 Mbs/sec. Interestingly, a while back we were running with the
> data directory mounted with forcedirectio and saw none of this, I'm
> guessing that fsync calls would have something to do with that?

Hmm ... no, because the stats file never gets fsync'd. I should think
that forcedirectio would have made things worse.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2007-12-04 00:35:32 Re: stored procedures and dynamic queries
Previous Message Matthew Dennis 2007-12-03 23:24:30 8.3 release notes