On 19/10/10 11:15, Dennis Gearon wrote:
I'm about to launch an in house 'Aplpha' stage project. One of the marketing
driven outputs on the page is filled by a:
SELECT
COUNT(*)
WHERE
date_field IS NOT NULL AND
date_field> :todays_date;
Last I heard, this kind of query is kind of slow on Postgres in particular,
(Love postgres otherwise). Is this still true?
That depends on the selectivity of your where clause, nothing else. If
date_field is indexed and pretty selective, it'll be quick.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
