Re: row is too big - Mailing list pgsql-general

From Tom Lane
Subject Re: row is too big
Date
Msg-id 14896.1314799850@sss.pgh.pa.us
Whole thread Raw
In response to row is too big  (Sim Zacks <sim@compulab.co.il>)
List 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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: heavy swapping, not sure why
Next
From: Tore Halvorsen
Date:
Subject: Index usage on OR queries