Re: disk spin down

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(at)localhost postmaster(at)fbi(dot)gov
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

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