How to see/calculate size of index in memory?

From: "Sam R(dot)" <samruohola(at)yahoo(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: How to see/calculate size of index in memory?
Date: 2018-09-19 08:30:49
Message-ID: 1101666388.6439182.1537345849495@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hi!

I would have following question, if someone could help.

Question 1: How to see/calculate size of index in memory?
BTree, hash index.

I can see size of index e.g. with pg_relation_size FROM pg_class (after reindex). Does that tell size of index on disk?

I would be interested how big part of index is in memory. (Whole index?)

PG10/PG11.
Best Regards, Sam

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sam R. 2018-09-19 08:35:38 To keep indexes in memory, is large enough effective_cache_size enough?
Previous Message Pavel Stehule 2018-09-19 08:30:31 Re: [HACKERS] proposal: schema variables