| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
| Cc: | josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: COMMIT NOWAIT Performance Option |
| Date: | 2007-02-27 22:17:45 |
| Message-ID: | 200702272217.l1RMHjZ15874@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jonah H. Harris wrote:
> On 2/27/07, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> > You're missing my point, which is that nobody has demonstrated that there
> > is any real performance gain from this. I see no reason to implement it
> > if there is no performance gain.
>
> While I'll back your request for results, it seems nearly impossible
> to expect no performance gain using this.
>
> Results never hurt though.
The results are going to be very close to fsync off for sufficiently
high values delay, and we _know_ fsync off is a performance win.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-02-27 22:18:28 | Re: COMMIT NOWAIT Performance Option |
| Previous Message | Bruce Momjian | 2007-02-27 21:37:46 | Re: COMMIT NOWAIT Performance Option |