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 B8A428B9D40 for ; Tue, 22 Feb 2005 20:07:29 +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 93623-02 for ; Tue, 22 Feb 2005 20:07:19 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 244878B9D1E for ; Tue, 22 Feb 2005 20:07:21 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j1MK7IbW093670 for ; Tue, 22 Feb 2005 20:07:18 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j1MK3HbN092264 for pgsql-admin@postgresql.org; Tue, 22 Feb 2005 20:03:17 GMT (envelope-from news) From: Indibil X-Newsgroups: pgsql.admin Subject: PostgreSQL 8.0.1 problem Date: Tue, 22 Feb 2005 21:03:17 +0100 Organization: Hub.Org Networking Services Lines: 25 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: usenet@news.hub.org User-Agent: KNode/0.7.6 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/231 X-Sequence-Number: 16399 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). Please, I need help. Thanks in advance. Indibil postscript: Sorry for my poor english.