Re: [GENERAL] The efficiency of the WAL log writer

2011-02-18 Thread Steven Elliott
On Thu, 2011-02-17 at 10:26 -0500, Tom Lane wrote: > Steven Elliott writes: > > I don't think the current behavior is particularly harmful, but maybe > > PostgreSQL could be made to idle more quietly. > > Yeah, this is something that's on my personal to-do list. It's not > really an efficiency/p

Re: [GENERAL] The efficiency of the WAL log writer

2011-02-17 Thread Tom Lane
Steven Elliott writes: > I don't think the current behavior is particularly harmful, but maybe > PostgreSQL could be made to idle more quietly. Yeah, this is something that's on my personal to-do list. It's not really an efficiency/performance issue, but in a machine that's otherwise idle this b

[GENERAL] The efficiency of the WAL log writer

2011-02-17 Thread Steven Elliott
Recently I became curious about the WAL log writer. I noticed that with a default ACID complaint configuration that the the WAL log writer wakes up every 200 msec (the default indicated by "wal_log_writer") and does nothing. Here's a typical strace: 21:37:07.194809 select(0, NULL, NULL, NULL, {