Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 8.0.1 problem

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Indibil <indibil(at)webmail(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.0.1 problem
Date: 2005-02-22 21:43:59
Message-ID: 1109108638.30529.123.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-admin
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...)

In response to

Responses

pgsql-admin by date

Next:From: Chris White (cjwhite)Date: 2005-02-22 22:46:12
Subject: 7.4.5 file write issue
Previous:From: Patrick MeylemansDate: 2005-02-22 21:30:14
Subject: Encoding types

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group