Re: int2 vs int4 in Postgres

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: int2 vs int4 in Postgres
Дата
Msg-id 1127764110.27799.2.camel@localhost.localdomain
обсуждение исходный текст
Ответ на int2 vs int4 in Postgres  ("Announce" <truthhurts@insightbb.com>)
Список pgsql-performance
On Mon, 2005-26-09 at 12:54 -0500, Announce wrote:
> Is there an performance benefit to using int2 (instead of int4) in cases
> where i know i will be well within its numeric range?

int2 uses slightly less storage space (2 bytes rather than 4). Depending
on alignment and padding requirements, as well as the other columns in
the table, that may translate into requiring fewer disk pages and
therefore slightly better performance and lower storage requirements.

-Neil



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: int2 vs int4 in Postgres
Следующее
От: Chris Browne
Дата:
Сообщение: Re: int2 vs int4 in Postgres