> On May 6, 2020, at 10:52 AM, Ashish Chugh <ashish.ch...@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.
