Обсуждение: performance

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

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.