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 0A0B09DC856 for ; Thu, 23 Feb 2006 12:45:05 -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 05189-09 for ; Thu, 23 Feb 2006 12:45:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 149649DC839 for ; Thu, 23 Feb 2006 12:45:01 -0400 (AST) Received: by fafnir.androme.com (Postfix, from userid 1003) id 03D4AB920B0; Thu, 23 Feb 2006 17:45:01 +0100 (CET) Message-ID: <43FDE698.4060707@andromeiberica.com> Date: Thu, 23 Feb 2006 17:45:12 +0100 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: Delete performance References: <1c66bda80602202302u2f6f6bc0jcfc3c728940ad2d0@mail.gmail.com> <15417.1140534087@sss.pgh.pa.us> <43FC2A5E.4080601@andromeiberica.com> <11337.1140618701@sss.pgh.pa.us> <43FD8E1F.8020704@andromeiberica.com> <22825.1140712500@sss.pgh.pa.us> In-Reply-To: <22825.1140712500@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.112 required=5 tests=[AWL=0.112] X-Spam-Score: 0.112 X-Spam-Level: X-Archive-Number: 200602/279 X-Sequence-Number: 20700 > Yes, if you are concerned about the performance of updates/deletes on > the departments table. The reason the system doesn't make such an index > automatically is that there are common scenarios where you seldom or > never update the master table, and so the index wouldn't repay the cost > it creates for updates of the slave table. Thanks for the explanations :-) regards -- Arnau