jair101 Posted November 16, 2019 Share Posted November 16, 2019 Is it normal that the index length of core_reputation_index is almost 5 times as big as the next table? I understand that it is ok for this table to have most rows, but the size of the index sounds a bit excessive compared to the other tables. Is it the same with you? Link to comment Share on other sites More sharing options...
jair101 Posted November 21, 2019 Author Share Posted November 21, 2019 Bump. Any idea? I might just drop and recreate the indices of this table, any risk in doing that? Link to comment Share on other sites More sharing options...
bfarber Posted November 21, 2019 Share Posted November 21, 2019 Out of curiosity....are you experiencing some sort of issue? If you start poking around and dropping things without good cause, you'll be likely to introduce a problem. Technically, yes you can drop and recreate indexes. I am not aware of any reasons this would change the size consumed. For reference, locally I see the following on a test installation: Data 1.2 MiB Index 1.9 MiB Overhead 19.6 KiB Effective 3 MiB Total 3 MiB Link to comment Share on other sites More sharing options...
Martin A. Posted November 21, 2019 Share Posted November 21, 2019 And this is what I have Data 448 MiB Index 1.2 GiB Overhead Effective 1.6 GiB Total 1.6 GiB Link to comment Share on other sites More sharing options...
jair101 Posted November 22, 2019 Author Share Posted November 22, 2019 Nope, not any issues, but I am always looking for a ways to optimize. Thanks, it seems that the size is as expected. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.