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
