Re: "select count(*) from contacts" is too slow!

From: nolan(at)celery(dot)tssi(dot)com
To: nandrews(at)investsystems(dot)co(dot)uk (Nigel J(dot) Andrews)
Cc: paul(dot)serby(at)clockltd(dot)com (Paul Serby), pgsql-general(at)postgresql(dot)org
Subject: Re: "select count(*) from contacts" is too slow!
Date: 2003-10-07 23:21:17
Message-ID: 20031007232117.17825.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> MySQL can tell you from it's index because it doesn't care if it gives you the
> right number or not.

Under what circumstances would MySQL give the wrong number?
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message D. Stimits 2003-10-07 23:25:37 PL/PGSQL for permutations?
Previous Message Zitan Broth 2003-10-07 21:41:32 Assigning Values to Arrays