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
