X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EBEDC528BE; Fri, 17 Jun 2005 01:39:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95344-10; Fri, 17 Jun 2005 04:39:23 +0000 (GMT) Received: from smtp02.syd.iprimus.net.au (smtp02.syd.iprimus.net.au [210.50.76.196]) by svr1.postgresql.org (Postfix) with ESMTP id 66AEF528CE; Fri, 17 Jun 2005 01:39:22 -0300 (ADT) Received: from [210.50.216.81] (210.50.216.81) by smtp02.syd.iprimus.net.au (7.2.060.1) id 42A0B1C10043E9AF; Fri, 17 Jun 2005 14:39:20 +1000 Message-ID: <42B25321.30507@iprimus.com.au> Date: Fri, 17 Jun 2005 14:35:45 +1000 From: David Dick User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-AU; rv:1.7.8) Gecko/20050511 X-Accept-Language: en-au, en MIME-Version: 1.0 To: "Marc G. Fournier" Cc: pgsql-sql@postgresql.org Subject: Re: Putting an INDEX on a boolean field? References: <20050617011336.Q90456@ganymede.hub.org> In-Reply-To: <20050617011336.Q90456@ganymede.hub.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.868 tagged_above=0 required=5 tests=DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: * X-Archive-Number: 200506/212 X-Sequence-Number: 21813 how about an very large table with a "processed" type flag? uru -Dave Marc G. Fournier wrote: > > Does that make sense? Would it ever get used? I can't see it, but > figured I'd ask ... > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >