Dear all, Is it possible to estimate btree index size on text field before creating it. For example i have a table like this: fortest=# \d index_estimate i integer somestring text This is avg bytes in text field fortest=# select round(avg(octet_length(somestring))) from index_estimate ; 4 And number of tuples is fortest=# select reltuples from pg_class where relname = 'index_estimate'; 10001 Can i estimate index size, operate only this data, may be exist formula or something to do this estimation. -- Best Regards, Seliavka Evgenii
