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?

 

Bump. Any idea? I might just drop and recreate the indices of this table, any risk in doing that?

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

And this is what I have

Data	448	MiB
Index	1.2	GiB
Overhead
Effective	1.6	GiB
Total	1.6	GiB

Nope, not any issues, but I am always looking for a ways to optimize. 

Thanks, it seems that the size is as expected.