X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6D30E4763BE for ; Tue, 22 Apr 2003 04:33:32 -0400 (EDT) Received: from houston.familyhealth.com.au (unknown [203.59.48.253]) by postgresql.org (Postfix) with ESMTP id 4B9934763B6 for ; Tue, 22 Apr 2003 04:33:30 -0400 (EDT) Received: (from root@localhost) by houston.familyhealth.com.au (8.11.6p2/8.11.6) id h3M8XUc02874 for pgsql-performance@postgresql.org; Tue, 22 Apr 2003 16:33:30 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Received: from mariner (mariner.internal [192.168.0.101]) by houston.familyhealth.com.au (8.11.6p2/8.9.3) with SMTP id h3M8XQJ02649; Tue, 22 Apr 2003 16:33:26 +0800 (WST) Message-ID: <024001c308a9$d8bd0f70$6500a8c0@fhp.internal> From: "Christopher Kings-Lynne" To: , "Josh Berkus" Cc: "Tom Lane" , "Kevin Brown" , References: <20030419130146.GI1847@filer> <21955.1050767928@sss.pgh.pa.us> <200304191203.18634.josh@agliodbs.com> <20030422032339.A37876@flake.decibel.org> Subject: Re: [SQL] Yet Another (Simple) Case of Index not used Date: Tue, 22 Apr 2003 16:33:27 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-scanner: scanned by Inflex 0.1.5c - (http://www.inflex.co.za/) X-Spam-Status: No, hits=-12.8 required=5.0 tests=BAYES_20,QUOTED_EMAIL_TEXT,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/189 X-Sequence-Number: 1695 > Once statement level triggers are implimented, the performance would > probably be fine, assuming your update was a single statement. Statement triggers _are_ implemented in CVS. Chris