disk spin down

Поиск
Список
Период
Сортировка
Искать

disk spin down

От:
Krammer Clemens <drk@w123.at>
Дата:
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 

Re: disk spin down

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

See in postgresql.conf:

	#checkpoint_timeout = 300       # range 30-3600, in seconds

That is what is causing it.

---------------------------------------------------------------------------

Krammer Clemens wrote:
> 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 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
  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
FAQ