| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-20 14:08:33 | Re: [BUGS] libpgtcl doesn't use UTF encoding of TCL |
| Previous Message | Lee Harr | 2001-07-19 19:00:59 | check contraint allows illegal value? |