Re: 7.4.5 file write issue - Mailing list pgsql-admin

From Chris White (cjwhite)
Subject Re: 7.4.5 file write issue
Date
Msg-id 200502230019.j1N0J9wN014673@sj-core-3.cisco.com
Whole thread Raw
In response to Re: 7.4.5 file write issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 7.4.5 file write issue  ("Chris White (cjwhite)" <cjwhite@cisco.com>)
List pgsql-admin
Thanks for information. We will have to look at the changes we made in
postgresql.conf.

Chris White

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Tuesday, February 22, 2005 3:45 PM
To: cjwhite@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] 7.4.5 file write issue

"Chris White (cjwhite)" <cjwhite@cisco.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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4.5 file write issue
Next
From: Devrim GUNDUZ
Date:
Subject: Re: 64 bit rpms for 7.4.7??