| From: | "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Slow inserts/deletes |
| Date: | 2001-05-29 20:02:25 |
| Message-ID: | B51F0C636E578A4E832D3958690CD73E0130BF1E@es04snlnt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi again,
I've got another database that I maintain which is suffering from extremely
slow record inserts or deletes.
The table has about 30K records in it. It has to simple indexes on it.
When I create the table from scratch and do all 30K inserts, it goes pretty
fast. When I then go back and do either an update-where, or a
delete-where/insert, it takes SEVERAL seconds! I thought that maybe
something had the table locked, so I rebooted the server and started
postgres manually; this didn't help the problem.
I need to get some ideas as to where to look.
Thanx,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl(at)sandia(dot)gov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-29 22:37:54 | Re: Slow inserts/deletes |
| Previous Message | Diehl, Jeffrey | 2001-05-29 19:57:58 | RE: Upgd from 7.0 to 7.1 |