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...)