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

Re: performance

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: performance
Date: 2001-07-19 21:11:54
Message-ID: 9j7ieq$1uic$1@node21.cwnet.roc.gblx.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Sat, 30 Jun 2001 13:10:17 +0800, Zhan Yi <yi_zhan(at)hotmail(dot)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.


In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2001-07-20 14:08:33
Subject: Re: [BUGS] libpgtcl doesn't use UTF encoding of TCL
Previous:From: Lee HarrDate: 2001-07-19 19:00:59
Subject: check contraint allows illegal value?

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