Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T7Bia-0002ax-L8; Thu, 30 Aug 2012 20:52:00 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T7BiZ-0005ND-NP; Thu, 30 Aug 2012 20:52:00 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q7UKputw001087; Thu, 30 Aug 2012 16:51:56 -0400 (EDT) From: Tom Lane To: Bruce Momjian cc: Tatsuo Ishii , pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: pg_dump and thousands of schemas In-reply-to: <20120830204433.GW8753@momjian.us> References: <20120529.185149.1127748531209576379.t-ishii@sraoss.co.jp> <12147.1338306742@sss.pgh.pa.us> <20120530.180620.600165924826262795.t-ishii@sraoss.co.jp> <20120531.092043.1953698679173443322.t-ishii@sraoss.co.jp> <20120830204433.GW8753@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Thu, 30 Aug 2012 16:44:33 -0400" Date: Thu, 30 Aug 2012 16:51:56 -0400 Message-ID: <1086.1346359916@sss.pgh.pa.us> X-Pg-Spam-Score: -2.1 (--) X-Archive-Number: 201208/195 X-Sequence-Number: 47733 Bruce Momjian writes: > On Thu, May 31, 2012 at 09:20:43AM +0900, Tatsuo Ishii wrote: >>> Ok, I modified the part of pg_dump where tremendous number of LOCK >>> TABLE are issued. I replace them with single LOCK TABLE with multiple >>> tables. With 100k tables LOCK statements took 13 minutes in total, now >>> it only takes 3 seconds. Comments? >> Shall I commit to master and all supported branches? > Was this applied? No, we fixed the server side instead. regards, tom lane