On 10/22/10 11:50 AM, sunpeng wrote:
what's the base of log_/a/ (/n/) function ? is that base a=16? or something else? how to know this base ?

2010/10/22 sunpeng <blueva...@gmail.com <mailto:blueva...@gmail.com>>

    Hi, how to get the height of R* or B tree of created index ?




it would be based on how many index values plus overhead fits in each 8K block. highly variable if the field being indexed is TEXT or VARCHAR or similar.



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

Reply via email to