Horton

Re: Win2K Questions

Charles H. Woloszynski <chw@clearmetrix.com>

View thread View on postgr.es
From: "Charles H. Woloszynski" <chw@clearmetrix.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-general@postgresql.org
Date: 2002-11-08T17:00:30Z
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