Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Yet Another (Simple) Case of Index not used

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [SQL] Yet Another (Simple) Case of Index not used
Date: 2003-04-20 16:46:09
Message-ID: 20030420164609.GA30629@libertyrms.info (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performancepgsql-sql
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(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2003-04-20 17:09:24
Subject: Re: [PERFORM] Foreign key performance
Previous:From: Stephan SzaboDate: 2003-04-20 16:04:10
Subject: Re: [PERFORM] Foreign key performance

pgsql-sql by date

Next:From: Tom LaneDate: 2003-04-20 22:29:57
Subject: Re: replicable problem with PL/Perl
Previous:From: Andreas PflugDate: 2003-04-20 15:37:57
Subject: Re: [SQL] Yet Another (Simple) Case of Index not used

pgsql-general by date

Next:From: Andrew SullivanDate: 2003-04-20 16:55:33
Subject: Re: default locale considered harmful? (was Re: Using index for "like 'ABC%'" type query)
Previous:From: Peter EisentrautDate: 2003-04-20 16:16:20
Subject: Re: default locale considered harmful? (was Re: [GENERAL]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group