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

Re: 7.4.5 file write issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cjwhite(at)cisco(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 7.4.5 file write issue
Date: 2005-02-22 23:44:51
Message-ID: 13401.1109115891@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Chris White (cjwhite)" <cjwhite(at)cisco(dot)com> writes:
> We are noticing on our 7.4.5 system the following files are being written
> approximately every 5 minutes

> /tmp/.s.PGSQL.5432
> /tmp/.s.PGSQL.5432.lock

> Anybody know why they are being written?

So they don't get eaten by overenthusiastic /tmp cleaner scripts.

> The reason I ask is because we are
> running on a system that uses a laptop disk drive and requires at least 10
> minutes idle time to spindown so it can recalibrate. This did not happen
> when we were running 7.4.2, so does anybody have any idea what may have
> changed between 7.4.2 and 7.4.5 to cause this to happen.

In 7.4 it's done every checkpoint.  Perhaps you changed your checkpoint
settings?

In 8.0 it looks like the interval is hardwired to 10 minutes; you'd have
to hack postmaster.c if you don't like it.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Chris White (cjwhite)Date: 2005-02-23 00:19:09
Subject: Re: 7.4.5 file write issue
Previous:From: Chris White (cjwhite)Date: 2005-02-22 22:46:12
Subject: 7.4.5 file write issue

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