Re: Use of fsync; was Re: [HACKERS] Pg_upgrade speed for many tables

2012-12-03 Thread Bruce Momjian
Applied. --- On Fri, Nov 30, 2012 at 10:43:29PM -0500, Bruce Momjian wrote: > On Mon, Nov 26, 2012 at 02:43:19PM -0500, Bruce Momjian wrote: > > > >> In any event, I think the documentation should caution that the > > > >> u

Re: Use of fsync; was Re: [HACKERS] Pg_upgrade speed for many tables

2012-11-30 Thread Bruce Momjian
On Mon, Nov 26, 2012 at 02:43:19PM -0500, Bruce Momjian wrote: > > >> In any event, I think the documentation should caution that the > > >> upgrade should not be deemed to be a success until after a system-wide > > >> sync has been done. Even if we use the link rather than copy method, > > >> are

Re: Use of fsync; was Re: [HACKERS] Pg_upgrade speed for many tables

2012-11-26 Thread Bruce Momjian
On Sat, Nov 24, 2012 at 09:42:08PM -0800, Jeff Janes wrote: > On Fri, Nov 23, 2012 at 7:22 PM, Bruce Momjian wrote: > > On Mon, Nov 19, 2012 at 12:11:26PM -0800, Jeff Janes wrote: > > > >> > >> Yes, it is with synchronous_commit=off. (or if it wasn't originally, > >> it is now, with the same resu

Re: Use of fsync; was Re: [HACKERS] Pg_upgrade speed for many tables

2012-11-24 Thread Jeff Janes
On Fri, Nov 23, 2012 at 7:22 PM, Bruce Momjian wrote: > On Mon, Nov 19, 2012 at 12:11:26PM -0800, Jeff Janes wrote: > >> >> Yes, it is with synchronous_commit=off. (or if it wasn't originally, >> it is now, with the same result) >> >> Applying your fsync patch does solve the problem for me on ext

Use of fsync; was Re: [HACKERS] Pg_upgrade speed for many tables

2012-11-23 Thread Bruce Momjian
On Mon, Nov 19, 2012 at 12:11:26PM -0800, Jeff Janes wrote: [ Sorry for the delay in replying.] > On Wed, Nov 14, 2012 at 3:55 PM, Bruce Momjian wrote: > > On Mon, Nov 12, 2012 at 10:29:39AM -0800, Jeff Janes wrote: > >> > >> Is turning off synchronous_commit enough? What about turning off fsy