Re: Slow inserts/deletes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Slow inserts/deletes
Date: 2001-05-29 22:37:54
Message-ID: 20046.991175874@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Diehl, Jeffrey" <jdiehl(at)sandia(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Swan 2001-05-29 22:41:19 Re: Upgd from 7.0 to 7.1
Previous Message Diehl, Jeffrey 2001-05-29 20:02:25 Slow inserts/deletes