pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Magnus Hagander <magnus@hagander.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Benjamin Minshall <minshall@intellicon.biz>
Cc: pgsql-performance@postgresql.org
Subject: Re: stats collector process high CPU utilization
Date: Fri, 02 Mar 2007 11:32:46 +0100
Message-ID: <45E7FD4E.6070101@hagander.net> (raw)
In-Reply-To: <28377.1172799353@sss.pgh.pa.us>
References: <45CB5D06.7090004@intellicon.biz>
	<20070209142459.GB4253@alvh.no-ip.org>
	<24717.1171033699@sss.pgh.pa.us>
	<29832.1171036557@sss.pgh.pa.us>
	<45CCA0DB.2010903@intellicon.biz>
	<1116.1171038786@sss.pgh.pa.us>
	<45CCBF13.2000707@intellicon.biz>
	<16282.1172779976@sss.pgh.pa.us>
	<b42b73150703011358p7dfe77dft85ba7f3cdd3ce160@mail.gmail.com>
	<17817.1172789069@sss.pgh.pa.us>
	<b42b73150703011730s7c6d4aaeo8d9206eab2594329@mail.gmail.com>
	<28377.1172799353@sss.pgh.pa.us>

Tom Lane wrote:
> "Merlin Moncure" <mmoncure@gmail.com> writes:
>> On 3/2/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> "Merlin Moncure" <mmoncure@gmail.com> writes:
>>>> I think this explains the trigger that was blowing up my FC4 box.
>>> I dug in the archives a bit and couldn't find the report you're
>>> referring to?
> 
>> I was referring to this:
>> http://archives.postgresql.org/pgsql-hackers/2007-02/msg01418.php
> 
> Oh, the kernel-panic thing.  Hm, I wouldn't have thought that replacing
> a file at a huge rate would induce a kernel panic ... but who knows?
> Do you want to try installing the one-liner patch and see if the panic
> goes away?
> 
> Actually I was wondering a bit if that strange Windows error discussed
> earlier today could be triggered by this behavior:
> http://archives.postgresql.org/pgsql-general/2007-03/msg00000.php

I think that's very likely. If we're updaitng the file *that* often,
we're certainly doing something that's very unusual for the windows
filesystem, and possibly for the hardware as well :-)

//Magnus



view thread (27+ messages)  latest in thread

Message-ID: <45E7FD4E.6070101@hagander.net>
Permalink:  ../45E7FD4E.6070101@hagander.net/
Also on:    postgresql.org/message-id/45E7FD4E.6070101@hagander.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: magnus@hagander.net, tgl@sss.pgh.pa.us, mmoncure@gmail.com, minshall@intellicon.biz
  Subject: Re: stats collector process high CPU utilization
  In-Reply-To: <45E7FD4E.6070101@hagander.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox