X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9E51BD1DD17 for ; Sat, 24 Jan 2004 01:45:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36395-01 for ; Fri, 23 Jan 2004 21:44:54 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 2DE8FD1E1E7 for ; Fri, 23 Jan 2004 21:44:50 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id i0O1iYpH008855; Fri, 23 Jan 2004 20:44:34 -0500 (EST) To: alvarezp@alvarezp.ods.org Cc: pgsql-performance@postgresql.org Subject: Re: Slow delete times?? In-reply-to: <3110.63.84.67.25.1074904710.squirrel@alvarezp.ods.org> References: <3110.63.84.67.25.1074904710.squirrel@alvarezp.ods.org> Comments: In-reply-to "Octavio Alvarez" message dated "Fri, 23 Jan 2004 16:38:30 -0800" Date: Fri, 23 Jan 2004 20:44:34 -0500 Message-ID: <8854.1074908674@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/253 X-Sequence-Number: 5427 "Octavio Alvarez" writes: > Please tell me if this timing makes sense to you for a Celeron 433 w/ > RAM=256MB dedicated testing server. I expected some slowness, but not this > high. I'll bet you have foreign keys referencing this table, and the referencing columns do not have indexes. PG will let you do that ... but it makes updates and deletes horribly slow. You generally want to add those indexes. If they *are* indexed, check for datatype mismatches. That's another thing that kills performance ... regards, tom lane