Re: [GENERAL] Row size overhead

2008-03-20 Thread Zubkovsky, Sergey
or near. Row overhead: 23 + 4 + 5 = 32 Total row size: 32 + 41 = 73 Unfortunately value '76' has an objective explanation. Thanks, Sergey Zubkovsky -Original Message- From: Adrian Klaver [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 5:44 PM To: pgsql-general@

Re: [GENERAL] Row size overhead

2008-03-20 Thread Zubkovsky, Sergey
ROTECTED] 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 that each row occupies 76 bytes approximately. > > But an

[GENERAL] Row size overhead

2008-03-19 Thread Zubkovsky, Sergey
bed in "53.3. Database Page Layout")? Is there a way to reduce these overheads? It may seem strange to you but in MSSQLServer2005 the same table occupies 150 MB only (47 bytes per row). Thanks in advance, Zubkovsky Sergey