pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
7.4.5 file write issue
10+ messages / 4 participants
[nested] [flat]

* 7.4.5 file write issue
@ 2005-02-22 22:46 Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-22 23:44 ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
  2005-03-05 09:29 ` Re: 7.4.5 file write issue Dmitry Morozovsky <marck@rinet.ru>
  0 siblings, 2 replies; 10+ messages in thread

From: Chris White (cjwhite) @ 2005-02-22 22:46 UTC (permalink / raw)
  To: pgsql-admin

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? 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.

TIA
Chris White



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
@ 2005-02-22 23:44 ` Tom Lane <tgl@sss.pgh.pa.us>
  2005-02-23 00:19   ` Re: 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  1 sibling, 1 reply; 10+ messages in thread

From: Tom Lane @ 2005-02-22 23:44 UTC (permalink / raw)
  To: cjwhite@cisco.com; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-22 23:44 ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-02-23 00:19   ` Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-23 00:59     ` Re: 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Chris White (cjwhite) @ 2005-02-23 00:19 UTC (permalink / raw)
  To: 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-22 23:44 ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
  2005-02-23 00:19   ` Re: 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
@ 2005-02-23 00:59     ` Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-23 05:05       ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 10+ messages in thread

From: Chris White (cjwhite) @ 2005-02-23 00:59 UTC (permalink / raw)
  To: cjwhite@cisco.com; 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Just checked and found that the checkpoint interval is the same between
7.4.2 and 7.4.5. We also brought up a 7.4.2 version and didn't see these
files being written/updated every 5 minutes. In which module are these files
created?

Chris White

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris White (cjwhite)
Sent: Tuesday, February 22, 2005 4:19 PM
To: 'Tom Lane'
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] 7.4.5 file write issue 

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-22 23:44 ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
  2005-02-23 00:19   ` Re: 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-02-23 00:59     ` Re: 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
@ 2005-02-23 05:05       ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 10+ messages in thread

From: Tom Lane @ 2005-02-23 05:05 UTC (permalink / raw)
  To: cjwhite@cisco.com; +Cc: pgsql-admin

"Chris White \(cjwhite\)" <cjwhite@cisco.com> writes:
> Just checked and found that the checkpoint interval is the same between
> 7.4.2 and 7.4.5. We also brought up a 7.4.2 version and didn't see these
> files being written/updated every 5 minutes. In which module are these files
> created?

See the TouchSocketLockFile calls in postmaster.c.  I'm pretty sure that
logic did not change between 7.4.2 and 7.4.5 ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
@ 2005-03-05 09:29 ` Dmitry Morozovsky <marck@rinet.ru>
  2005-03-11 03:21   ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 1 reply; 10+ messages in thread

From: Dmitry Morozovsky @ 2005-03-05 09:29 UTC (permalink / raw)
  To: Chris White (cjwhite) <cjwhite@cisco.com>; +Cc: pgsql-admin

On Tue, 22 Feb 2005, Chris White (cjwhite) wrote:

CWc> We are noticing on our 7.4.5 system the following files are being written
CWc> approximately every 5 minutes
CWc> 
CWc> /tmp/.s.PGSQL.5432
CWc> /tmp/.s.PGSQL.5432.lock
CWc> 
CWc> Anybody know why they are being written? The reason I ask is because we are
CWc> running on a system that uses a laptop disk drive and requires at least 10
CWc> minutes idle time to spindown so it can recalibrate. This did not happen
CWc> when we were running 7.4.2, so does anybody have any idea what may have
CWc> changed between 7.4.2 and 7.4.5 to cause this to happen.

What about switching to memory-based /tmp ?

Sincerely,
D.Marck                                     [DM5020, MCK-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-03-05 09:29 ` Re: 7.4.5 file write issue Dmitry Morozovsky <marck@rinet.ru>
@ 2005-03-11 03:21   ` Bruce Momjian <pgman@candle.pha.pa.us>
  2005-03-11 04:41     ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 10+ messages in thread

From: Bruce Momjian @ 2005-03-11 03:21 UTC (permalink / raw)
  To: Dmitry Morozovsky <marck@rinet.ru>; +Cc: Chris White (cjwhite) <cjwhite@cisco.com>; pgsql-admin

Dmitry Morozovsky wrote:
> On Tue, 22 Feb 2005, Chris White (cjwhite) wrote:
> 
> CWc> We are noticing on our 7.4.5 system the following files are being written
> CWc> approximately every 5 minutes
> CWc> 
> CWc> /tmp/.s.PGSQL.5432
> CWc> /tmp/.s.PGSQL.5432.lock
> CWc> 
> CWc> Anybody know why they are being written? The reason I ask is because we are
> CWc> running on a system that uses a laptop disk drive and requires at least 10
> CWc> minutes idle time to spindown so it can recalibrate. This did not happen
> CWc> when we were running 7.4.2, so does anybody have any idea what may have
> CWc> changed between 7.4.2 and 7.4.5 to cause this to happen.
> 
> What about switching to memory-based /tmp ?

If you take a look at postmaster.c you will see:

        /*
         * Touch the socket and lock file at least every ten minutes, to
         * ensure that they are not removed by overzealous /tmp-cleaning
         * tasks.
         */
        now = time(NULL);
        if (now - last_touch_time >= 10 * 60)
        {
            TouchSocketFile();
            TouchSocketLockFile();
            last_touch_time = now;
        }

I would change the "10" to perhaps "60" and try that.

I am now thinking we need to make this "10" a GUC variable for just such
cases.  This is not the first request for this.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-03-05 09:29 ` Re: 7.4.5 file write issue Dmitry Morozovsky <marck@rinet.ru>
  2005-03-11 03:21   ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
@ 2005-03-11 04:41     ` Tom Lane <tgl@sss.pgh.pa.us>
  2005-03-11 16:48       ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 10+ messages in thread

From: Tom Lane @ 2005-03-11 04:41 UTC (permalink / raw)
  To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Dmitry Morozovsky <marck@rinet.ru>; Chris White (cjwhite) <cjwhite@cisco.com>; pgsql-admin

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I am now thinking we need to make this "10" a GUC variable for just such
> cases.  This is not the first request for this.

At most it's the second or third request ... and this is hardly the only
repetitive disk hit in Postgres.  I can't get excited about it.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-03-05 09:29 ` Re: 7.4.5 file write issue Dmitry Morozovsky <marck@rinet.ru>
  2005-03-11 03:21   ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
  2005-03-11 04:41     ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-03-11 16:48       ` Bruce Momjian <pgman@candle.pha.pa.us>
  2005-03-24 05:19         ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 10+ messages in thread

From: Bruce Momjian @ 2005-03-11 16:48 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Dmitry Morozovsky <marck@rinet.ru>; Chris White (cjwhite) <cjwhite@cisco.com>; pgsql-admin

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I am now thinking we need to make this "10" a GUC variable for just such
> > cases.  This is not the first request for this.
> 
> At most it's the second or third request ... and this is hardly the only
> repetitive disk hit in Postgres.  I can't get excited about it.

Should we update the 'touch' on the file to once an hour perhaps?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: 7.4.5 file write issue
  2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
  2005-03-05 09:29 ` Re: 7.4.5 file write issue Dmitry Morozovsky <marck@rinet.ru>
  2005-03-11 03:21   ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
  2005-03-11 04:41     ` Re: 7.4.5 file write issue Tom Lane <tgl@sss.pgh.pa.us>
  2005-03-11 16:48       ` Re: 7.4.5 file write issue Bruce Momjian <pgman@candle.pha.pa.us>
@ 2005-03-24 05:19         ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 10+ messages in thread

From: Bruce Momjian @ 2005-03-24 05:19 UTC (permalink / raw)
  To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Dmitry Morozovsky <marck@rinet.ru>; Chris White (cjwhite) <cjwhite@cisco.com>; pgsql-admin

Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > I am now thinking we need to make this "10" a GUC variable for just such
> > > cases.  This is not the first request for this.
> > 
> > At most it's the second or third request ... and this is hardly the only
> > repetitive disk hit in Postgres.  I can't get excited about it.
> 
> Should we update the 'touch' on the file to once an hour perhaps?

Timer changes to once every hour rather than every 10 minutes.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2005-03-24 05:19 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-22 22:46 7.4.5 file write issue Chris White (cjwhite) <cjwhite@cisco.com>
2005-02-22 23:44 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-23 00:19   ` Chris White (cjwhite) <cjwhite@cisco.com>
2005-02-23 00:59     ` Chris White (cjwhite) <cjwhite@cisco.com>
2005-02-23 05:05       ` Tom Lane <tgl@sss.pgh.pa.us>
2005-03-05 09:29 ` Dmitry Morozovsky <marck@rinet.ru>
2005-03-11 03:21   ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-03-11 04:41     ` Tom Lane <tgl@sss.pgh.pa.us>
2005-03-11 16:48       ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-03-24 05:19         ` Bruce Momjian <pgman@candle.pha.pa.us>

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