Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5F84F2E323F for ; Wed, 2 Jan 2008 12:02:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 04440-02 for ; Wed, 2 Jan 2008 12:02:19 -0400 (AST) Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 21F712E0140 for ; Wed, 2 Jan 2008 12:02:19 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id AC614B255B for ; Wed, 2 Jan 2008 17:02:17 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id aeHJaRcUab8C for ; Wed, 2 Jan 2008 17:02:17 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 9AFBFB2550; Wed, 2 Jan 2008 17:02:17 +0100 (CET) Date: Wed, 2 Jan 2008 17:02:17 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Performance tuning... Message-ID: <20080102160217.GA29499@easy2.in-chemnitz.de> References: <3D51BC79-C289-4B35-B1B1-078F82D00A1A@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3D51BC79-C289-4B35-B1B1-078F82D00A1A@indiana.edu> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/15 X-Sequence-Number: 27789 Hi Carol, On Wed, Jan 02, 2008 at 10:34:47AM -0500, Carol Walter wrote: > This has probably been discussed a number of times, but I really need > your help. I am upgrading from 8.1 to 8.2. Right now I have the > restore of the database to the new version running. It has been > running since December 21, at 4:30 PM. I'm in a University > environment and we're in the midst of winter break, so there is very > little processing going on on my systems. This is actually a test > run of the upgrade. I thought I would be able to do the test and > live during the break but as slow as this thing is going, I may be > lucky just to finish the test. This brings me to my question. Is > there any performance tuning I can do to make this think run faster? > This is a Sun box running Solaris 10. The restore has been running for over 12 days now? How large is the database? Did you adjust any settings in postgresql.conf (probably based on the 8.1 ones)? Do you see anything in PostgreSQL's log file? What kind of machine are you using (there are a lot of different Sun boxes...) Bye, Tino. -- www.craniosacralzentrum.de www.spiritualdesign-chemnitz.de Tino Schwarze * Parkstraße 17h * 09120 Chemnitz