How many levels a B-tree has?

Поиск
Список
Период
Сортировка
От Cris
Тема How many levels a B-tree has?
Дата
Msg-id 200305141609.h4EG9sG27003@cancerberus.com
обсуждение исходный текст
Ответы Re: How many levels a B-tree has?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,[I'm not sure if this will be the best word to express the thing I
mean, because I've been reading some papers, and mail archives that have
been looked for by this word, and I haven't got any result, so I would do my
best.]I need to know (if it possible) how many LEVELS a B-tree index
has (to know how many accesses to the disk it would do in a query). I could
know the index size, but no-idea to find out how many levels it has.
I've read about pg_index, but there isn't any about.There is any way to
do it?ThanksCris..

В списке pgsql-general по дате отправления:

Предыдущее
От: Todd Nemanich
Дата:
Сообщение: Questions regarding stored procedures
Следующее
От: "alex b."
Дата:
Сообщение: Re: COPY versus INSERT