Re: **SPAM** Faster count(*)?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: **SPAM** Faster count(*)?
Дата
Msg-id 20050810105059.GA5448@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: **SPAM** Faster count(*)?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Tue, Aug 09, 2005 at 10:49:14PM -0400, Tom Lane wrote:
> 
> Current best practice is to run the explain and parse out the "rows"
> figure using a perl (or axe-of-choice) regexp, though we could be
> persuaded to supply a simpler API if there's enough demand for it.

FWIW, this was another one of those things I must have heard a dozen
times at OSCON.  I suspect the simpler API would be popular,
particularly since post-8.0 the estimates are more reliable than they
used to be.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: **SPAM** Faster count(*)?
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: **SPAM** Faster count(*)?