pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Slow inserts/deletes
3+ messages / 3 participants
[nested] [flat]

* Slow inserts/deletes
@ 2001-05-29 20:02 Diehl, Jeffrey <jdiehl@sandia.gov>
  2001-05-29 22:37 ` Re: Slow inserts/deletes Tom Lane <tgl@sss.pgh.pa.us>
  2001-05-30 21:21 ` Re: Slow inserts/deletes Frank Contrepois <sokak@tin.it>
  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 20:02 Slow inserts/deletes Diehl, Jeffrey <jdiehl@sandia.gov>
@ 2001-05-29 22:37 ` Tom Lane <tgl@sss.pgh.pa.us>
  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-29 20:02 Slow inserts/deletes Diehl, Jeffrey <jdiehl@sandia.gov>
@ 2001-05-30 21:21 ` Frank Contrepois <sokak@tin.it>
  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