: 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
and see what happens to table
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
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