Compute the number of tuples in a block

From: Pei He <hepeimail(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Compute the number of tuples in a block
Date: 2010-09-22 03:42:15
Message-ID: AANLkTim8rGufvnD-X6FnyemweE7Su-L3-d+W+6hdaOaJ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
In ctid, there are the block num, and the tuple offset inside the block.

How can I know the maximum number of tuples in a block?
The block size would be BLCKSZ.

I am not quite sure where is the best place to find the size of the tuple in
a table.

Thanks
--
Pei

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-09-22 03:47:30 Re: Multi-branch committing in git, revisited
Previous Message Tom Lane 2010-09-22 03:35:12 Re: Multi-branch committing in git, revisited