Re: [GENERAL] 7.1 Beta 1 & table size calculation

2000-12-21 Thread Tom Lane
"Dale Anderson" <[EMAIL PROTECTED]> writes: > Is the relpages counts under 7.1 no longer valid of the physical page > storage? It's still valid, but you need to include the associated TOAST table as well as the primary relation. Keep in mind also that TOAST can do inline compression. If you mad

[GENERAL] 7.1 Beta 1 & table size calculation

2000-12-21 Thread Dale Anderson
I am looking at 7.1 beta 1 to see how my application (currently on 7.0.3) will operate under 7.1. To calculate used space, in 7.0.3, I lookup the relpages count for the table in pg_class and multiply it by 8 (8k is my block size). In my testing of 7.1 beta 1, I created a record of length