Re: why does count take so long?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: why does count take so long?
Дата
Msg-id 87he3n56d7.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: why does count take so long?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: why does count take so long?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Something I've wanted to do for awhile is to look at making int8 and
> float8 be pass-by-value datatypes on machines where Datum is naturally
> 8 bytes (ie, any 8-byte-pointer architecture).  I doubt it would be a
> win to widen Datum on 32-bit machines, though; the distributed costs
> would swamp the advantage from making these datatypes more efficient.

Things like count(*) could use int4 until it overflows though.
Is int4 a pass-by-value datatype on 32-bit machines?

--
greg

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: decrypted pwd
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Can I use PostgreSQL to develop a self-organizing