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 C2036EB3-1B4B-4C56-9D68-9803FC3E4A04@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 table size.
Список pgsql-general
Дерево обсуждения


On May 6, 2020, at 5:48 AM, Ram Pratap Maurya <ram.maurya@lavainternational.in> wrote:

Hi Team,
 
We are facing a problem in our PostgreSQL production database related to abnormal growth of index size. Some of the indexes are having abnormal growth and index size is larger than table data size.
One table is having 75 G.B of index though table size is only 25 G.B. On monthly basis we are performing vacuum to release the used space.
 
I am attaching the screen shot for your reference. Could you please help us in resolving the same as this is degrading performance drastically.
 
<image002.png>


How many indexes are there in the table tstock_movement?  Could it be that 65GB is the sum total of index size of all indexes.

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

Предыдущее
От: Ram Pratap Maurya
Дата:
Сообщение: Abnormal Growth of Index Size - Index Size 3x large than table size.
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Lock Postgres account after X number of failed logins?