estimate btree index size without creating - Mailing list pgsql-performance

From Евгений Селявка
Subject estimate btree index size without creating
Date
Msg-id CAKPhvNaqxycnwDh+cq1mkKAEvNCeNOZRxq1+Qz5ty-_cSECJYg@mail.gmail.com
Whole thread Raw
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions
Next
From: johno
Date:
Subject: Re: Slow query with indexed ORDER BY and LIMIT when using OR'd conditions