Reporting as requested by https://www.redhat.com/archives/fedora-devel-list/2007-August/msg00544.html On an otherwise idle system, the postgres "logger process" is waking up once a second and the postgres "writer process" wakes up 5 times a second so postgres wakes up at least 6 times a second by default. You can slow down the writer process by tweaking the bgwriter_delay setting (default is 200ms, perhaps it should be larger for your typical system?) A quick perusal of the docs doesn't reveal how to modify the wakeup interval of the logger process, but I may have missed it.
This is unlikely to change ... the upstream Postgres project's goals do not include zeroing out CPU cycles, and I'm not about to try to make the Fedora edition be optimized differently. There is some marginal interest in not waking up the hard drive unnecessarily, but you have not stated that that's happening.
I would hope the upstream postgres project goals include datacenter suitability.. by wasting electricity this way.... it's not ;) (this isn't about cpu cycles. this is about electricity)
I guess this is the same bug I am seeing. On an updated Rawhide system, postmaster process is waking up the cpu 6.5 times per second: 48,9% ( 6,5) postmaster : schedule_timeout (process_timeout) In my case this is the worst offender on an otherwise quiet system running a Gnome session. The next offender is the kernel with 2 wps: 15,0% ( 2,0) <kernel core> : clocksource_register (clocksource_watchdog) Is there something that can be done to solve this? I took a quick look on the postgres web site but I didn't find a bugzilla to reference this bug. I'll try IRC later. I agree with Arjan, this is something that should be one of the goals of the postgres project. I think that in a not too distant future this will be an important selling point.
This message is a reminder that Fedora 7 is nearing the end of life. Approximately 30 (thirty) days from now Fedora will stop maintaining and issuing updates for Fedora 7. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At that time this bug will be closed as WONTFIX if it remains open with a Fedora 'version' of '7'. Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, simply change the 'version' to a later Fedora version prior to Fedora 7's end of life. Bug Reporter: Thank you for reporting this issue and we are sorry that we may not be able to fix it before Fedora 7 is end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora please change the 'version' of this bug. If you are unable to change the version, please add a comment here and someone will do it for you. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete. If possible, it is recommended that you try the newest available Fedora distribution to see if your bug still exists. Please read the Release Notes for the newest Fedora distribution to make sure it will meet your needs: http://docs.fedoraproject.org/release-notes/ The process we are following is described here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
This is still affects all versions of Postgres - updating version from 7 to 9 to keep it from being closed with F7 bugs.
This message is a reminder that Fedora 9 is nearing its end of life. Approximately 30 (thirty) days from now Fedora will stop maintaining and issuing updates for Fedora 9. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At that time this bug will be closed as WONTFIX if it remains open with a Fedora 'version' of '9'. Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, simply change the 'version' to a later Fedora version prior to Fedora 9's end of life. Bug Reporter: Thank you for reporting this issue and we are sorry that we may not be able to fix it before Fedora 9 is end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora please change the 'version' of this bug to the applicable version. If you are unable to change the version, please add a comment here and someone will do it for you. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete. The process we are following is described here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
This bug appears to have been reported against 'rawhide' during the Fedora 13 development cycle. Changing version to '13'. More information and reason for this action is here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
This message is a reminder that Fedora 13 is nearing its end of life. Approximately 30 (thirty) days from now Fedora will stop maintaining and issuing updates for Fedora 13. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At that time this bug will be closed as WONTFIX if it remains open with a Fedora 'version' of '13'. Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, simply change the 'version' to a later Fedora version prior to Fedora 13's end of life. Bug Reporter: Thank you for reporting this issue and we are sorry that we may not be able to fix it before Fedora 13 is end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora please change the 'version' of this bug to the applicable version. If you are unable to change the version, please add a comment here and someone will do it for you. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete. The process we are following is described here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
As a note, this issue *is* being looked at upstream, and I hope to see some real progress in Postgres 9.2 or so.
Thanks for the update, Tom - moving version to F15 (last version I've seen the issue) since the earliest we might see this fix is in F16. Is there an upstream ticket for this? Happy to close this here and mark it upstream.
Given the upstream release schedule, F18 is more likely :-( Upstream doesn't use a formal bug ticketing mechanism, but the first piece of the fix is being tracked here: https://commitfest.postgresql.org/action/patch_view?id=560
This message is a notice that Fedora 15 is now at end of life. Fedora has stopped maintaining and issuing updates for Fedora 15. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At this time, all open bugs with a Fedora 'version' of '15' have been closed as WONTFIX. (Please note: Our normal process is to give advanced warning of this occurring, but we forgot to do that. A thousand apologies.) Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, feel free to reopen this bug and simply change the 'version' to a later Fedora version. Bug Reporter: Thank you for reporting this issue and we are sorry that we were unable to fix it before Fedora 15 reached end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora, you are encouraged to click on "Clone This Bug" (top right of this page) and open it against that version of Fedora. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete. The process we are following is described here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping