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 AFA435366D for ; Fri, 25 Mar 2005 10:47:05 +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 31219-05 for ; Fri, 25 Mar 2005 10:47:03 +0000 (GMT) Received: from mailgate3.nau.edu (mailgate3.nau.edu [134.114.96.145]) by svr1.postgresql.org (Postfix) with ESMTP id 292475365D for ; Fri, 25 Mar 2005 10:47:02 +0000 (GMT) Received: from CONVERSION-DAEMON.mailgate3.nau.edu by mailgate3.nau.edu (PMDF V6.2-X17 #30845) id <0IDW00001LYGQS@mailgate3.nau.edu> for pgsql-performance@postgresql.org; Fri, 25 Mar 2005 03:47:05 -0700 (MST) Received: from k2.cet.nau.edu (net9-213.cet.nau.edu [134.114.9.213]) by mailgate3.nau.edu (PMDF V6.2-X17 #30845) with ESMTP id <0IDW0000OLYGKE@mailgate3.nau.edu>; Fri, 25 Mar 2005 03:47:04 -0700 (MST) Date: Fri, 25 Mar 2005 03:50:36 -0700 From: Karim Nassar Subject: Re: [BUGS] BUG #1552: massive performance hit between 7.4 In-reply-to: <1111745917.11750.713.camel@localhost.localdomain> To: Simon Riggs Cc: Keith Browne , Brian O'Reilly , pgsql-performance@postgresql.org Message-id: <1111747837.898.19.camel@k2.cet.nau.edu> MIME-version: 1.0 X-Mailer: Evolution 2.0.2 Content-type: text/plain Content-transfer-encoding: 7BIT References: <20050318232102.08FA0F0E5D@svr2.postgresql.org> <1111567230.11750.596.camel@localhost.localdomain> <4241C1DF.2020000@deepsky.com> <1111745917.11750.713.camel@localhost.localdomain> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/594 X-Sequence-Number: 11299 On Fri, 2005-03-25 at 10:18 +0000, Simon Riggs wrote: > > When running with PostgreSQL 7.4 on a dual-CPU Athlon MP2400+ machine > > with a gigabyte of RAM, running Debian Linux version 2.6.8.1, we were > > able to insert all this data in 5-7 minutes. It's taken a while to > > install Postgres 8.0.1 on the same machine, but now I have, and it's > > taking 40-45 minutes to run the same insert script. > OK. Not-a-bug. > > Your situation is covered in the manual with some sage advice > http://www.postgresql.org/docs/8.0/static/populate.html > It doesn't go into great lengths about all the reasons why those > recommendations are good ones - but they are clear. Simon, this begs the question: what changed from 7.4->8.0 to require he modify his script? TIA, -- Karim Nassar Department of Computer Science Box 15600, College of Engineering and Natural Sciences Northern Arizona University, Flagstaff, Arizona 86011 Office: (928) 523-5868 -=- Mobile: (928) 699-9221