Re: : Performance Improvement Strategy - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: : Performance Improvement Strategy
Date
Msg-id 4E8C3BF70200002500041AAF@gw.wicourts.gov
Whole thread Raw
In response to Re: : Performance Improvement Strategy  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-performance
Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
> Venkat Balaji <venkat.balaji@verse.in>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

pgsql-performance by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: : Performance Improvement Strategy
Next
From: Scott Marlowe
Date:
Subject: Re: : Performance Improvement Strategy