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