Re: row is too big

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: row is too big
Дата
Msg-id 14896.1314799850@sss.pgh.pa.us
обсуждение исходный текст
Ответ на row is too big  (Sim Zacks <sim@compulab.co.il>)
Список pgsql-general
Sim Zacks <sim@compulab.co.il> writes:
> The manual doesn't say exactly how much storage a numeric type uses, but
> it seems to me that it is taking up about 12 bytes per field. Does this
> make any sense?

Yeah, that would be the minimum size of a nonzero numeric value in 8.2.
(More recent versions can pack them a bit tighter in many cases.)

You might consider whether you can put all those numeric fields into an
array.

            regards, tom lane

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: heavy swapping, not sure why
Следующее
От: Tore Halvorsen
Дата:
Сообщение: Index usage on OR queries