Just checked and found that the checkpoint interval is the same between 7.4.2 and 7.4.5. We also brought up a 7.4.2 version and didn't see these files being written/updated every 5 minutes. In which module are these files created?
Chris White -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris White (cjwhite) Sent: Tuesday, February 22, 2005 4:19 PM To: 'Tom Lane' Cc: [email protected] Subject: Re: [ADMIN] 7.4.5 file write issue Thanks for information. We will have to look at the changes we made in postgresql.conf. Chris White -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Tuesday, February 22, 2005 3:45 PM To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: [ADMIN] 7.4.5 file write issue "Chris White (cjwhite)" <[EMAIL PROTECTED]> writes: > We are noticing on our 7.4.5 system the following files are being > written approximately every 5 minutes > /tmp/.s.PGSQL.5432 > /tmp/.s.PGSQL.5432.lock > Anybody know why they are being written? So they don't get eaten by overenthusiastic /tmp cleaner scripts. > The reason I ask is because we are > running on a system that uses a laptop disk drive and requires at > least 10 minutes idle time to spindown so it can recalibrate. This did > not happen when we were running 7.4.2, so does anybody have any idea > what may have changed between 7.4.2 and 7.4.5 to cause this to happen. In 7.4 it's done every checkpoint. Perhaps you changed your checkpoint settings? In 8.0 it looks like the interval is hardwired to 10 minutes; you'd have to hack postmaster.c if you don't like it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
