Re: [GENERAL] row is too big

2011-08-31 Thread Tom Lane
Sim Zacks 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

[GENERAL] row is too big

2011-08-31 Thread Sim Zacks
select version() "PostgreSQL 8.2.19 on i686-pc-linux-gnu, compiled by GCC gcc (Debian 4.3.2-1.1) 4.3.2" Before you jump down my throat about bad design, this is a reporting table that is generated based on what the users want to see in their rows and columns. (I'm basically generating a sprea