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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to