Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics

Поиск
Список
Период
Сортировка
От Alexey Dokuchaev
Тема Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Дата
Msg-id 20180521172435.GA12264@regency.nsu.ru
обсуждение исходный текст
Ответ на Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, May 21, 2018 at 12:54:56PM -0400, Tom Lane wrote:
> Alexey Dokuchaev <danfe@nsu.ru> writes:
> > Quick reality check question: are count(*) vs. count(_) equivalent
> > above?
> 
> Only if _ is guaranteed non-null ... which, as a rowtype result, it
> probably is.  But I'd use count(*) if you're concerned about speed.

Understood.  Yes, my primary concern (after correctness) is speed.  Thank
you all again for very helpful and prompt replies guys.

./danfe


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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?
Следующее
От: "Bartosz Dmytrak"
Дата:
Сообщение: posgresql.log