Slow inserts/deletes

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-sql by date

  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