On Tue, 12 Feb 2002, Chris Gamache wrote:
> Computing the amount of disk space it would take to house the full text index
> on one of the fields in my database:
>
> 36 bytes: each row header (approximate)
> + 53 bytes Varchar(53)
> + 8 bytes: oid field
> + 4 bytes: pointer on page to tuple
> ----------------------------------------
> 101 bytes per row
Well, varchar(53) should be I think 4 bytes + length of string
(4-57 bytes, not a constant 53), but that's likely to be no more
than a 25-30% reduction overall (depends on your average string lengths).
