Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-09-04 Thread Simon Riggs
On Fri, 2006-08-18 at 08:52 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: On Thu, 2006-08-17 at 19:11 -0400, Tom Lane wrote: I noticed a minor annoyance while testing: when the system is completely idle, you get a forced segment switch every checkpoint_timeout seconds, even

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-18 Thread Simon Riggs
On Thu, 2006-08-17 at 19:11 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Revised patch enclosed, now believed to be production ready. This implements regular log switching using the archive_timeout GUC. Further patch enclosed implementing these changes plus the record type

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-18 Thread Zeugswetter Andreas DCP SD
I noticed a minor annoyance while testing: when the system is completely idle, you get a forced segment switch every checkpoint_timeout seconds, even though there is nothing useful to log. The checkpoint code is smart enough not to do a checkpoint if nothing has happened since the last

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-18 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Thu, 2006-08-17 at 19:11 -0400, Tom Lane wrote: I noticed a minor annoyance while testing: when the system is completely idle, you get a forced segment switch every checkpoint_timeout seconds, even though there is nothing useful to log. The checkpoint

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-17 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: Revised patch enclosed, now believed to be production ready. This implements regular log switching using the archive_timeout GUC. Further patch enclosed implementing these changes plus the record type version of pg_xlogfile_name_offset() Applied with

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-17 Thread Florian G. Pflug
Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: Revised patch enclosed, now believed to be production ready. This implements regular log switching using the archive_timeout GUC. Further patch enclosed implementing these changes plus the record type version of pg_xlogfile_name_offset()

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-04 Thread Simon Riggs
On Thu, 2006-08-03 at 19:03 +0100, Simon Riggs wrote: On Thu, 2006-08-03 at 13:38 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: WIP archive_timeout. All we need to do is add LWLock support to archiver. Thoughts/ideas/hints welcome. Hint: this isn't the archiver's

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-03 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: WIP archive_timeout. All we need to do is add LWLock support to archiver. Thoughts/ideas/hints welcome. Hint: this isn't the archiver's problem, and so you don't need to get the archiver involved in the solution. I'd suggest bgwriter as a reasonably

Re: [HACKERS] [PATCHES] WIP archive_timeout patch

2006-08-03 Thread Simon Riggs
On Thu, 2006-08-03 at 13:38 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: WIP archive_timeout. All we need to do is add LWLock support to archiver. Thoughts/ideas/hints welcome. Hint: this isn't the archiver's problem, and so you don't need to get the archiver involved in