From: | Dennis Gearon <gearond(at)sbcglobal(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | select count(*) status these days |
Date: | 2010-10-19 00:15:14 |
Message-ID: | 123082.49872.qm@web82103.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Is there any architectural way to speed it up? I'd actually like to run it every 2-60 seconds to update a counter on a page for the marketing guy, (which for once, is me :-)
Dennis Gearon
Signature Warning
----------------
It is always a good idea to learn from your own mistakes. It is usually a better idea to learn from others’ mistakes, so you do not have to make them yourself. from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036'
EARTH has a Right To Life,
otherwise we all die.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2010-10-19 00:20:29 | Re: installing from source in Windows |
Previous Message | Turner, John J | 2010-10-18 21:58:38 | Re: installing from source in Windows |