X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9940F8B9D4E for ; Tue, 22 Feb 2005 21:44:11 +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 23842-05 for ; Tue, 22 Feb 2005 21:44:08 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 4CF6D8B9B27 for ; Tue, 22 Feb 2005 21:44:01 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 22 Feb 2005 15:43:59 -0600 Subject: Re: PostgreSQL 8.0.1 problem From: Scott Marlowe To: Indibil Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1109108638.30529.123.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 22 Feb 2005 15:43:59 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/239 X-Sequence-Number: 16407 On Tue, 2005-02-22 at 14:03, Indibil wrote: > Hi: > > I want migrate to PostgreSQL 8.0.1 for Windows from PostgreSQL 7.4.1, but I > have a big problem. > > In 7.4.1 I have a large view with nested views. It lasts 1 minute and 20 > seconds to finish. In 8.0.1 for Windows it lasts.... I don't know. One > hour, two hour, one day... I always cancel the view because it lasts > forever. > > Shared buffers and work mem in 8.0.1 are greater than those of 7.4.1. So I > think this isn't a memory problem. Furthermore, the 8.0.1 server has double > RAM than 7.4 server. The "simples" views work right. But when I run the > large view the problem appears. > > The database was migrated with pg_dumpall (8.0.1 version) and restored with > psql (8.0.1 version). Have you run vacuum analyze on the new database? Are the postgresql.conf files pretty much the same (except for the renaming and moving around caused by it being an 8.0 .conf file...)