Re: : Performance Improvement Strategy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx> wrote:
> Venkat Balaji <venkat.balaji@xxxxxxxx>wrote:
 
>> [attempt to calculate file space from row layout and number of
>> rows]
 
> One more point to add to this good discussion, each row header
> will occupy 24 bytes + 4 bytes pointer on page to tuple.
 
Not to mention:
 
http://www.postgresql.org/docs/9.1/interactive/storage-toast.html
 
-Kevin

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux