X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 34DA83A581B for ; Thu, 2 Dec 2004 17:58:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38343-10 for ; Thu, 2 Dec 2004 17:58:21 +0000 (GMT) Received: from mail1.catalyst.net.nz (godel.catalyst.net.nz [202.49.159.12]) by svr1.postgresql.org (Postfix) with ESMTP id 29E463A5800 for ; Thu, 2 Dec 2004 17:58:21 +0000 (GMT) Received: from leibniz.catalyst.net.nz ([202.49.159.7] helo=lamb.mcmillan.net.nz) by mail1.catalyst.net.nz with asmtp (TLS-1.0:DHE_RSA_3DES_EDE_CBC_SHA:24) (Exim 4.34) id 1CZvDc-0001Bf-8e; Fri, 03 Dec 2004 06:58:16 +1300 Received: from lamb.mcmillan.net.nz (lamb.mcmillan.net.nz [127.0.0.1]) by lamb.mcmillan.net.nz (Postfix) with ESMTP id 0A612AD98588; Fri, 3 Dec 2004 06:58:16 +1300 (NZDT) Subject: Re: pg_restore taking 4 hours! From: Andrew McMillan To: grupos@carvalhaes.net Cc: pgsql-performance@postgresql.org In-Reply-To: <41ADA82A.7070405@carvalhaes.net> References: <41ADA82A.7070405@carvalhaes.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-KTKbSKVDNPY56RbXwJLa" Date: Fri, 03 Dec 2004 06:58:15 +1300 Message-Id: <1102010295.16058.271.camel@lamb.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/60 X-Sequence-Number: 9435 --=-KTKbSKVDNPY56RbXwJLa Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2004-12-01 at 09:16 -0200, Rodrigo Carvalhaes wrote: >=20 > I am using PostgreSQL with a proprietary ERP software in Brazil. The=20 > database have around 1.600 tables (each one with +/- 50 columns). ... > max_fsm_pages =3D 20000 > max_fsm_relations =3D 1000 Hi, I doubt that this will improve your pg_restore performance, but if you have 1600 tables in the database then you very likely want to increase the above two settings. In general max_fsm_relations should be more than the total number of tables across all databases in a given installation. The best way to set these is to do a "VACUUM VERBOSE", which will print the appropriate minimum numbers at the end of the run, along with the current setting. Cheers, Andrew. ------------------------------------------------------------------------- Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)803-2201 MOB: +64(272)DEBIAN OFFICE: +64(4)499-2267 Never trust a computer you can't repair yourself. ------------------------------------------------------------------------- --=-KTKbSKVDNPY56RbXwJLa Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBBr1e3jJA0f48GgBIRAiq9AJ9NJA5X1owQanYDLknTLzIsIK6hMQCdGYks Zs2drMLOi5ncwJK6g9FEl2U= =8mf8 -----END PGP SIGNATURE----- --=-KTKbSKVDNPY56RbXwJLa--