pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSlow inserts/deletes
3+ messages / 3 participants
[nested] [flat]
* Slow inserts/deletes
@ 2001-05-29 20:02 Diehl, Jeffrey <jdiehl@sandia.gov>
0 siblings, 2 replies; 3+ messages in thread
From: Diehl, Jeffrey @ 2001-05-29 20:02 UTC (permalink / raw)
To: 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@sandia.gov
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Slow inserts/deletes
@ 2001-05-29 22:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: Diehl, Jeffrey <jdiehl@sandia.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2001-05-29 22:37 UTC (permalink / raw)
To: Diehl, Jeffrey <jdiehl@sandia.gov>; +Cc: pgsql-sql
"Diehl, Jeffrey" <jdiehl@sandia.gov> writes:
> I've got another database that I maintain which is suffering from extremely
> slow record inserts or deletes.
Can't give you any help on the basis of the info you provided. How
about telling us: the PG version in question, the schema(s) of the
table(s) used ("pg_dump -s -t tabname dbname" is the best way here),
the exact queries you're having trouble with, and the output of
EXPLAIN for those queries.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Slow inserts/deletes
@ 2001-05-30 21:21 Frank Contrepois <sokak@tin.it>
parent: Diehl, Jeffrey <jdiehl@sandia.gov>
1 sibling, 0 replies; 3+ messages in thread
From: Frank Contrepois @ 2001-05-30 21:21 UTC (permalink / raw)
To: pgsql-sql
If you use index on this table it's better to:
1) drop all index on the table
2) do the insert
3) (re)create the indexes
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-05-30 21:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-29 20:02 Slow inserts/deletes Diehl, Jeffrey <jdiehl@sandia.gov>
2001-05-29 22:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-05-30 21:21 ` Frank Contrepois <sokak@tin.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox