Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize.

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize.
Дата
Msg-id 0A85F167-F350-4F26-9E7A-BFAF784B0E1A@comcast.net
обсуждение исходный текст
Ответ на Abnormal Growth of Index Size - Index Size 3x large than table size.  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
Ответы RE: Abnormal Growth of Index Size - Index Size 3x large than tablesize.
Список pgsql-general
Дерево обсуждения


On May 6, 2020, at 10:52 AM, Ashish Chugh <ashish.chugh@lavainternational.in> wrote:

Hello Ravi,


Total number of indexes are 10 and size is 65 GB. Shall we consider this as a normal scenario or we need to look into the growth of the indexes as this is increasing day by day and table data is not increasing so drastically. Due to this performance degradation is there and we have to run full vacuum on monthly basis.

Table size is only 25 gb.

Any help in this regard is appreciable.

Indexes are stored just like tables. From storage perspective there is no difference between a table and an index.
So the sum of 10 different tables to 65GB, compared to 25GB of one table sounds possible.

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Lock Postgres account after X number of failed logins?
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Lock Postgres account after X number of failed logins?