Re: Hardware/OS recommendations for large databases (

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Hardware/OS recommendations for large databases (
Дата
Msg-id 438586D3.9010701@paradise.net.nz
обсуждение исходный текст
Ответ на Re: Hardware/OS recommendations for large databases (  ("Luke Lonergan" <llonergan@greenplum.com>)
Список pgsql-performance
Luke Lonergan wrote:

> That says it's something else in the path.  As you probably know there is a
> page lock taken, a copy of the tuple from the page, lock removed, count
> incremented for every iteration of the agg node on a count(*).  Is the same
> true of a count(1)?
>

Sorry Luke - message 3 - I seem to be suffering from a very small
working memory buffer myself right now, I think it's after a day of
working with DB2 ... :-)

Anyway, as I read src/backend/parser/gram.y:6542 - count(*) is
transformed into count(1), so these two are identical.

Cheers (last time tonight, promise!)

Mark

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

Предыдущее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Hardware/OS recommendations for large databases (
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Hardware/OS recommendations for large databases (