Postgres Pro
Downloads
Home   >   mailing lists

Re: performance - Mailing list pgsql-bugs

From missive@frontiernet.net (Lee Harr)
Subject Re: performance
Date
Msg-id 9j7ieq$1uic$1@node21.cwnet.roc.gblx.net
Whole thread Raw
In response to performance  ("Zhan Yi" <yi_zhan@hotmail.com>)
List pgsql-bugs
Tree view 
On Sat, 30 Jun 2001 13:10:17 +0800, Zhan Yi <yi_zhan@hotmail.com> wrote:
> I found performance problem.
>
> createdb            speed fast
>
> after many inserts, updates then delete all from tables and redo the same
> thing
>                     speed degrade
>
> drop table and rebuild table redo operations
>                     speed fast


Make sure you read the manual regarding VACUUM. This sounds like
it could be related to needing to VACUUM your tables.

The good news is that it looks like 7.2 will have a much better
way of dealing with the need to VACUUM.

pgsql-bugs by date:

Previous
From: "Bob Soeters"
Date:
Subject: Re: Two foreign keys in one table both referencing same record in primary table gives error on update of primary table
Next
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: check contraint allows illegal value?