Full Text Indexing...

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

The data page size in PostgreSQL is 8192 bytes (8 KB), so:

8192 bytes per page
------------------- = 82 rows per database page (rounded up)
101 bytes per row

561062644 data rows
-------------------- = 6842228 database pages
82 rows per page

6842228 database pages * 8192 bytes per page = 56,051,531,776 bytes (56 GB)

Is my math right??? WOW! This thing is HUUUGE!

Table "title_fti"
Attribute | Type | Modifier
-----------+-----------------------+----------
string | character varying(53) |
id | oid |

When I index the oid, and the string,oid I'll get roughly another 75-100MB,
yes?

Ayn tips/tricks, or am I just going to have to add another 100MB to my server?

CG

__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com