On Sat, 30 Jun 2001 13:10:17 +0800, Zhan Yi <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
