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 880309DCB76 for ; Tue, 29 Nov 2005 16:36:39 -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 23696-08 for ; Tue, 29 Nov 2005 16:36:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 5A7F39DCAD4 for ; Tue, 29 Nov 2005 16:36:35 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 29 Nov 2005 14:36:35 -0600 Subject: Re: Delete slow... From: Scott Marlowe To: Diego Cc: pgsql-admin@postgresql.org In-Reply-To: <438CC8FB.6040001@unimedijui.com.br> References: <438CC473.9030409@unimedijui.com.br> <1133295605.28236.1.camel@ekim> <438CC8FB.6040001@unimedijui.com.br> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1133296595.28788.75.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 29 Nov 2005 14:36:35 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/330 X-Sequence-Number: 19703 On Tue, 2005-11-29 at 15:32, Diego wrote: > Thanks by answers... > > For each record deleted, my postgresql server spended 4 seconds... > I know because i have logged each sql instruction, showing the time spended. > > My question is: is normal this time to a big table (400,000 records) Do you have any foreign keys involved here? You might need some indexes for faster lookups. And don't worry about your english, I'm sure it's 1,000 times better than most of our Portuguese.