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 upgrade

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 we sure that

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 br...@momjian.us 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

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 br...@momjian.us 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

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 br...@momjian.us wrote: On Mon, Nov 12, 2012 at 10:29:39AM -0800, Jeff Janes wrote: Is turning off synchronous_commit enough? What about turning