Re: Fixed width rows faster?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Fixed width rows faster?
Дата
Msg-id 200403051537.02535.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Fixed width rows faster?  (Dennis Bjorklund <db@zigo.dhs.org>)
Список pgsql-performance
Jeff:

> As far as I know there is only a small win when you want to extract some
> field from a tuple and with variable width fields you have to walk to the
> correct field. But this is a small performance problem unless you have
> very many variable size columns in the table.

BTW, Dennis here is not talking about CHAR; CHAR is handled as a
variable-length field in Postgres.    INTEGER is a fixed-width field.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Fixed width rows faster?
Следующее
От: Mike Nolan
Дата:
Сообщение: Re: Fixed width rows faster?