| From: | "Charles H(dot) Woloszynski" <chw(at)clearmetrix(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Win2K Questions |
| Date: | 2002-11-08 17:00:30 |
| Message-ID: | 3DCBEDAE.2030102@clearmetrix.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Huxton wrote:
>Depends on usage patterns and how you build your application. There are a
>couple of oddities with workarounds: count() and max() aren't very optimised
>for example.
>
You can 'fix' the max() SNAFU with a new query of the form
"select field from tbl limit 1 order by field desc" (not precise syntax, but the idea is correct)
I call it a SNAFU since it I hate to have to change queries from something obvious to a more obscure format just to work around an optimizer issue.
Not sure if there is an equivalent query to make count() work faster
Charlie
--
Charles H. Woloszynski
ClearMetrix, Inc.
115 Research Drive
Bethlehem, PA 18015
tel: 610-419-2210 x400
fax: 240-371-3256
web: www.clearmetrix.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-11-08 17:14:59 | Re: Win2K Questions |
| Previous Message | Aragorn | 2002-11-08 17:00:25 | Basic Trigger Question |