ma...@kset.org writes:
> Is there a reason pg_column_size returns different sizes for a constant
> and the same value from a table column?
The constant probably has the default choice of a four-byte length word,
while the on-disk form has been compressed by switching to a one-byte
length word.
Hi,
I was calculating row sizes with pg_column_size and came to this strange
result:
CREATE TABLE t1(
c1 NUMERIC(10,7) NOT NULL DEFAULT 123.1234567
);
INSERT INTO t1(c1) VALUES (DEFAULT);
SELECT pg_column_size(c1) AS first,
pg_column_size(123.1234567::NUMERIC(10,7)) as second, c1 =
123
Hi,I'm trying to find the size of individual rows in a database (or a subset of them) so that we can tell users how much of a quota they are using on the system (in practice this will actually be across a number of tables and I will need to write a query to do this). I have come across pg_column_si
