pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 8.0.1 problem
4+ messages / 3 participants
[nested] [flat]
* PostgreSQL 8.0.1 problem
@ 2005-02-22 20:03 Indibil <indibil@webmail.co.za>
2005-02-22 21:43 ` Re: PostgreSQL 8.0.1 problem Scott Marlowe <smarlowe@g2switchworks.com>
0 siblings, 1 reply; 4+ messages in thread
From: Indibil @ 2005-02-22 20:03 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL 8.0.1 problem
2005-02-22 20:03 PostgreSQL 8.0.1 problem Indibil <indibil@webmail.co.za>
@ 2005-02-22 21:43 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-02-23 23:15 ` Re: PostgreSQL 8.0.1 problem Indibil <indibil@webmail.co.za>
0 siblings, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2005-02-22 21:43 UTC (permalink / raw)
To: Indibil <indibil@webmail.co.za>; +Cc: 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...)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL 8.0.1 problem
2005-02-22 20:03 PostgreSQL 8.0.1 problem Indibil <indibil@webmail.co.za>
2005-02-22 21:43 ` Re: PostgreSQL 8.0.1 problem Scott Marlowe <smarlowe@g2switchworks.com>
@ 2005-02-23 23:15 ` Indibil <indibil@webmail.co.za>
0 siblings, 0 replies; 4+ messages in thread
From: Indibil @ 2005-02-23 23:15 UTC (permalink / raw)
To: pgsql-admin
I run vacuum analyze and the view WORKS!!
A lot of thanks Scott, (one thousand or more ;)
Indibil
Scott Marlowe wrote:
> 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...)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL 8.0.1 problem
@ 2005-02-23 15:15 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 4+ messages in thread
From: Magnus Hagander @ 2005-02-23 15:15 UTC (permalink / raw)
To: Indibil <indibil@webmail.co.za>; pgsql-admin
> 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.
Did you run VACUUM ANALYZE on the restored database?
//Magnus
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-02-23 23:15 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-22 20:03 PostgreSQL 8.0.1 problem Indibil <indibil@webmail.co.za>
2005-02-22 21:43 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-02-23 23:15 ` Indibil <indibil@webmail.co.za>
2005-02-23 15:15 Re: PostgreSQL 8.0.1 problem Magnus Hagander <mha@sollentuna.net>
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