disk spin down - Mailing list pgsql-admin

From Krammer Clemens
Subject disk spin down
Date
Msg-id 20020912072305.GA22563@212186138149.15.tuwien.teleweb.at
Whole thread Raw
Responses Re: disk spin down  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
hello there,

i found out that postgresql server prevents my ata disk from spinning
down.

it is not the logging i think. stracing the father process brings out
that every 5 minutes a child process does access a file:

11:50:13 fork()                         = 4988
[pid  4988] 11:50:13 close(3)           = 0
[pid  4988] 11:50:13 close(4)           = 0
[pid  4988] 11:50:13 close(6)           = 0
[pid  4988] 11:50:13 close(7)           = 0
[pid  4988] 11:50:13 getpid()           = 4988
[pid  4988] 11:50:13 open("/var/lib/postgres/data/PG_VERSION", O_RDONLY)
= 3
[pid  4988] 11:50:13 fstat64(3, {st_mode=S_IFREG|0600, st_size=4, ...})
= 0
[pid  4988] 11:50:13 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4001a000
[pid  4988] 11:50:13 read(3, "7.2\n", 4096) = 4
[pid  4988] 11:50:13 close(3)           = 0

hmm.. maybe this is the course?



best regards,
clemens

--


* Spammers read: root@localhost postmaster@fbi.gov


pgsql-admin by date:

Previous
From: "shreedhar"
Date:
Subject: Function For Newly INSERTED VALUE
Next
From: Mats Lofkvist
Date:
Subject: Re: fsync or fdatasync