Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4TMc6E25629 for ; Tue, 29 May 2001 18:38:06 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4TMbsR20049; Tue, 29 May 2001 18:37:58 -0400 (EDT) To: "Diehl, Jeffrey" cc: pgsql-sql@postgresql.org Subject: Re: Slow inserts/deletes In-reply-to: References: Comments: In-reply-to "Diehl, Jeffrey" message dated "Tue, 29 May 2001 14:02:25 -0600" Date: Tue, 29 May 2001 18:37:54 -0400 Message-ID: <20046.991175874@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/320 X-Sequence-Number: 3161 "Diehl, Jeffrey" 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