Egregoros

Make pernia unfollow you with this one simple trick.

@phnt be correct at him.

@f0x Correct, that's how it happened probably.

@phnt @f0x more like, argue in bad faith until i get sick of you.

@pernia @f0x I'm sorry for explaining to you how Postgres indexes work and how the underlying source type has no effect on the size of the index, because you didn't understand that. I won't bother next time

@phnt @f0x dude, you are actually just strawmanning me.

i know that the fact its a jsonb structure has nothing to do with the size. the *size* of the row is what makes the index huge.

this is what i'm talking about. you're actually just bullshitting me. and you do this with every single question (that i ask you in good faith) at you.

@pernia @f0x
>the *size* of the row is what makes the index huge

This in fact for the third time is not the case. The size of the index is influenced by the size of the indexed part and how many rows the index has. You can have a 5MB row to index, index a 2048 byte part of it and the entry in the index would be the same size if the row was 5KB. Why would an index size be influenced by something it never indexes?

Don't believe me, I've attached a clanker answer as well.
image.png
image.png