Re: Make COUNT(*) Faster?

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Make COUNT(*) Faster?
Дата
Msg-id m37jg1p6ly.fsf@mobile.int.cbbrowne.com
обсуждение исходный текст
Ответ на Make COUNT(*) Faster?  (Varun Mehta <vmehta@apple.com>)
Ответы Re: Make COUNT(*) Faster?  (Steve Wampler <swampler@noao.edu>)
Список pgsql-sql
> I'm also claiming that a true count for any active table is
> meaningless and am *not* suggesting that effort be spent on trying
> to produce such a true count.

That's a pretty big assumption that would in fact be WRONG.

We have managers interested in counting the number of objects we have
around (As a domain registry, what objects would you imagine those
might be :-)), and they're keen on possibly even being able to
reconcile those counts from day to day based on transaction activity.

Leaping into some sort of vague guesstimation would destroy the
ability to do any kind of analysis of activity, and I daresay enrage
them.

There may be times that a really rough guess can suffice; there are
other times when exactness is absolutely vital.

Creating a "fast but WRONG COUNT(*)" which prevented getting the exact
answer that the present implementation provides would be a severe
misfeature.
-- 
output = reverse("gro.gultn" "@" "enworbbc")
http://linuxdatabases.info/info/rdbms.html
"The  test of a  principle  is whether it  applies  even to people you
don't like." -- Henry Spencer


В списке pgsql-sql по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Index creation question for expression (col1 || '-' || col2)
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Index creation question for expression (col1 || '-' || col2)