X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1755E9DCBB7 for ; Tue, 29 Nov 2005 16:20:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22094-10 for ; Tue, 29 Nov 2005 16:20:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by postgresql.org (Postfix) with ESMTP id 4F21B9DCAD4 for ; Tue, 29 Nov 2005 16:20:06 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 7AD7017A4D; Tue, 29 Nov 2005 21:20:01 +0100 (CET) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 15430-01; Tue, 29 Nov 2005 21:20:01 +0100 (CET) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id 3AE9717A40; Tue, 29 Nov 2005 21:20:01 +0100 (CET) Subject: Re: Delete slow... From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Diego Cc: pgsql-admin@postgresql.org In-Reply-To: <438CC473.9030409@unimedijui.com.br> References: <438CC473.9030409@unimedijui.com.br> Content-Type: text/plain Organization: Mob-Art Date: Tue, 29 Nov 2005 21:20:05 +0100 Message-Id: <1133295605.28236.1.camel@ekim> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/328 X-Sequence-Number: 19701 On Tue, 2005-11-29 at 18:13 -0300, Diego wrote: > Hi, > I have a table with 400,000 records, but in delete comand is very slow > (4 seconds for operation) > Why is very slow? There is some special configuration for this? > > Ps.: Version = Postgresql 7.4.6 That smells like a bad design. What do you delete from a 400.000 records table? I guess it's ok to be slow. Mike -- Mario Splivalo Mob-Art mario.splivalo@mobart.hr "I can do it quick, I can do it cheap, I can do it well. Pick any two."