Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UoiTI-0006Kq-MI for pgsql-admin@arkaria.postgresql.org; Mon, 17 Jun 2013 23:04:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UoiTH-0000Yf-TH for pgsql-admin@arkaria.postgresql.org; Mon, 17 Jun 2013 23:04:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UoiTG-0000YY-S6 for pgsql-admin@postgresql.org; Mon, 17 Jun 2013 23:04:22 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UoiTD-0003XM-AP for pgsql-admin@postgresql.org; Mon, 17 Jun 2013 23:04:22 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1UoiTB-0000Yx-2d; Mon, 17 Jun 2013 19:04:17 -0400 Date: Mon, 17 Jun 2013 19:04:17 -0400 From: Bruce Momjian To: Lonni J Friedman Cc: Matheus de Oliveira , "pgsql-admin@postgresql.org" Subject: Re: pg_upgrade with -j shows no perf improvement Message-ID: <20130617230417.GA1997@momjian.us> References: <20130616030313.GA22904@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Mon, Jun 17, 2013 at 10:26:48AM -0700, Lonni J Friedman wrote: > >> I only have 1 tablespace, although I have 9 databases. However, one > >> of the databases is about 95% of the total on-disk space, so that's > >> probably the explanation of why -j isn't helping me? > >> > > > > That is probably why you DID had some improvement, although so little. Agreed. > >> I don't have sufficient disk space to efficiently test --link mode, > >> unless there's some way to quickly roll back to the pre-upgrade > >> version of the database after a --link mode upgrade has completed > >> successfully that I'm not seeing? > >> > > > > I didn't got it. AFAIK, in link mode it would take **less** space than > > normal mode, not the opposite. Am I wrong? > > No, you're correct, but I want to keep the old version unchanged after > the upgrade. I didn't think that was possible with link mode. It is not possible in link mode if you start the new cluster. If you don't start the new cluster, you can just delete the new cluster and restart the unchanged old cluster, thought you have to remove the .old suffix on the control file. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin