Re: [HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-10 Thread Andrew Dunstan
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Maybe we should lower the autovac naptime too, just to make it do some more stuff (and to see if it breaks something else just because of being running). Well, Andrew has committed the pg_regress extension to allow buildfarm

[HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-09 Thread Tom Lane
When I was playing with pgbench testing yesterday, one thing that seemed a bit odd was that turning off synchronous_commit didn't change the results noticeably. It took till today for the reason to penetrate my cranium: it was off already.

Re: [HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-09 Thread Andrew Dunstan
Tom Lane wrote: We've had that hack in there for almost a month now, and no strange behaviors have turned up in the buildfarm. So I'm inclined to think it has served its purpose, and we should revert it before anyone else comes to bogus conclusions about performance. This is particularly the

Re: [HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-09 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: We've had that hack in there for almost a month now, and no strange behaviors have turned up in the buildfarm. So I'm inclined to think it has served its purpose, and we should revert it before anyone else comes to bogus conclusions about performance. This

Re: [HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-09 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: We've had that hack in there for almost a month now, and no strange behaviors have turned up in the buildfarm. So I'm inclined to think it has served its purpose, and we should revert it before anyone else comes to

Re: [HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-09 Thread Alvaro Herrera
Gregory Stark wrote: Tom Lane [EMAIL PROTECTED] writes: We've had that hack in there for almost a month now, and no strange behaviors have turned up in the buildfarm. So I'm inclined to think it has served its purpose, and we should revert it before anyone else comes to bogus

Re: [HACKERS] Are we done with sync-commit-defaults-to-off patch?

2007-09-09 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Maybe we should lower the autovac naptime too, just to make it do some more stuff (and to see if it breaks something else just because of being running). Well, Andrew has committed the pg_regress extension to allow buildfarm animals to set nondefault