| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-04-20 16:55:33 | Re: default locale considered harmful? (was Re: Using index for "like 'ABC%'" type query) |
| Previous Message | Peter Eisentraut | 2003-04-20 16:16:20 | Re: default locale considered harmful? (was Re: [GENERAL] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-20 17:09:24 | Re: [PERFORM] Foreign key performance |
| Previous Message | Stephan Szabo | 2003-04-20 16:04:10 | Re: [PERFORM] Foreign key performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-20 22:29:57 | Re: replicable problem with PL/Perl |
| Previous Message | Andreas Pflug | 2003-04-20 15:37:57 | Re: [SQL] Yet Another (Simple) Case of Index not used |