X-Original-To: pgsql-performance@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 10ED7475FBA
	for <pgsql-performance@postgresql.org>;
	Sun, 20 Apr 2003 12:46:05 -0400 (EDT)
Received: from mail.libertyrms.com (unknown [209.167.124.227])
	by postgresql.org (Postfix) with ESMTP id 4AD82475F1C
	for <pgsql-performance@postgresql.org>;
	Sun, 20 Apr 2003 12:46:04 -0400 (EDT)
Received: from [10.1.2.130] (helo=dba2)
	by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian))
	id 197HxC-0000yd-00
	for <pgsql-performance@postgresql.org>; Sun, 20 Apr 2003 12:46:10 -0400
Received: by dba2 (Postfix, from userid 1019)
	id E1636CF3A; Sun, 20 Apr 2003 12:46:09 -0400 (EDT)
Date: Sun, 20 Apr 2003 12:46:09 -0400
From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: [SQL] Yet Another (Simple) Case of Index not used
Message-ID: <20030420164609.GA30629@libertyrms.info>
Mail-Followup-To: Andrew Sullivan <andrew@libertyrms.info>,
	pgsql-performance@postgresql.org
References: <EKEBJNAJDPKJBDFGJNIJAENMDBAA.denis@next2me.com>
	<200304090918.45275.josh@agliodbs.com>
	<20030419130146.GI1847@filer> <21955.1050767928@sss.pgh.pa.us>
	<20030420011336.GJ1847@filer> <24735.1050809664@sss.pgh.pa.us>
	<20030420062852.GK1847@filer> <26961.1050852092@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <26961.1050852092@sss.pgh.pa.us>
User-Agent: Mutt/1.5.3i
X-Spam-Status: No, hits=-38.0 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT
	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/181
X-Sequence-Number: 1687

On Sun, Apr 20, 2003 at 11:21:32AM -0400, Tom Lane wrote:

> favor the other operations.  If you've designed an application that
> lives or dies by fast COUNT(*), perhaps you should choose another
> database.

Or consider redesigning the application.  The "no where clause"
restriction sure smacks of poor database normalisation to me.  

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110