From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Indibil <indibil@webmail.co.za>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 8.0.1 problem
Date: Tue, 22 Feb 2005 15:43:59 -0600
Message-ID: <1109108638.30529.123.camel@state.g2switchworks.com> (raw)
In-Reply-To: <cvg2cq$2ln1$1@news.hub.org>
References: <cvg2cq$2ln1$1@news.hub.org>
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...)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: smarlowe@g2switchworks.com, indibil@webmail.co.za
Subject: Re: PostgreSQL 8.0.1 problem
In-Reply-To: <1109108638.30529.123.camel@state.g2switchworks.com>
References: <cvg2cq$2ln1$1@news.hub.org> <1109108638.30529.123.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox