X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D368ED1E9A7 for ; Thu, 29 Apr 2004 16:23:10 -0300 (ADT) 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 27231-09 for ; Thu, 29 Apr 2004 16:22:51 -0300 (ADT) Received: from gpdnet.co.uk (gpdnet.plus.com [212.56.100.243]) by svr1.postgresql.org (Postfix) with ESMTP id 92DEED1E5DC for ; Thu, 29 Apr 2004 16:22:48 -0300 (ADT) Received: from gary (unverified [192.168.1.2]) by gpdnet.co.uk (SurgeMail 1.8g3) with ESMTP id 226 for ; Thu, 29 Apr 2004 20:22:17 +0100 From: "Gary Doades" To: pgsql-performance@postgresql.org Date: Thu, 29 Apr 2004 20:23:19 +0100 MIME-Version: 1.0 Subject: Re: planner/optimizer question Message-ID: <40916437.19555.148E3602@localhost> In-reply-to: <1083265934.30065.359.camel@jester> References: <409153EF.24647.144E9BF7@localhost> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Server: High Performance Mail Server - http://surgemail.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/500 X-Sequence-Number: 6800 > > I guess the real question is, why maintain index flags and not simply > drop the index entry altogether? > > A more interesting case would be to have the backend process record > index tuples that it would invalidate (if committed), then on commit > send that list to a garbage collection process. > > It's still vacuum -- just the reaction time for it would be much > quicker. > This was my original question. I guess the problem is with MVCC. The row may have gone from your current view of the table but not from someone elses. I don't (yet) understand the way it works to say for sure, but I still think it is worth pursuing further for someone who does know the deep stuff. They seem to have concluded that it is not worth it however. Cheers, Gary.