Re: When to REINDEX a serial key?

Поиск
Список
Период
Сортировка
От Ron
Тема Re: When to REINDEX a serial key?
Дата
Msg-id 4cc31261-a074-f756-9739-c53400dd298b@gmail.com
обсуждение исходный текст
Ответ на Re: When to REINDEX a serial key?  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: When to REINDEX a serial key?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Список pgsql-general
On 7/6/21 4:52 AM, David Rowley wrote:
> On Tue, 6 Jul 2021 at 21:35, Ron <ronljohnsonjr@gmail.com> wrote:
>> The legacy RDBMS which I used to manage has a tool for analyzing (not in the Postgresql meaning of the word) an
index,and displaying a histogram of how many layers deep various parts of an index are.  Using that histogram, you can
tellwhether or not an index needs to be rebuilt.
 
>>
>> How does one get the same effect in Postgresql?
> There are a few suggestions in
> https://wiki.postgresql.org/wiki/Show_database_bloat

How does bloat relate to a lopsided b-tree?

-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: Sudheer H R
Дата:
Сообщение: Re: Question about how to handle numeric (decimal) data types while using libpq
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: When to REINDEX a serial key?