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@sandia.gov