: Wednesday, March 19, 2008 8:23 PM
To: Zubkovsky, Sergey
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Row size overhead
2008/3/19 Zubkovsky, Sergey [EMAIL PROTECTED]:
Simple calculations show that each row occupies 76 bytes
approximately.
But anticipated row size would be 41 or near
size.
-Original Message-
From: Pavan Deolasee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 8:23 PM
To: Zubkovsky, Sergey
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Row size overhead
2008/3/19 Zubkovsky, Sergey [EMAIL PROTECTED]:
Simple calculations show
: [GENERAL] Row size overhead
On Thursday 20 March 2008 7:24 am, Zubkovsky, Sergey wrote:
Thanks for your reply.
I had used PG 8.3.1 on 32-bit WinXP platform.
PostgreSQL 8.3.1, compiled by Visual C++ build 1400
But I suppose this fact doesn't change anything essentially.
Thanks,
Sergey
Hi,
I have a table
CREATE TABLE MsgCommon
(
UTC timestamp without time zone NOT NULL,
UID bigint NOT NULL,
DataSourceID integer NOT NULL,
DataSourceType integer NOT NULL,
BSCArchive boolean NOT NULL,
Oddities integer NOT NULL,
Encapsulated boolean NOT NULL,
2008/3/19 Zubkovsky, Sergey [EMAIL PROTECTED]:
Simple calculations show that each row occupies 76 bytes approximately.
But anticipated row size would be 41 or near.
You haven't mentioned PG version. For 8.2 onwards, the tuple header is
23 bytes. Add another 4 bytes for one line pointer for