Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g2Xwy-0007ji-4z for pgsql-performance@arkaria.postgresql.org; Wed, 19 Sep 2018 08:35:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g2Xww-0007F0-7j for pgsql-performance@arkaria.postgresql.org; Wed, 19 Sep 2018 08:35:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g2Xwv-0007Et-JI for pgsql-performance@lists.postgresql.org; Wed, 19 Sep 2018 08:35:06 +0000 Received: from sonic303-29.consmr.mail.bf2.yahoo.com ([74.6.131.228]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g2Xwr-0000DO-Gg for pgsql-performance@lists.postgresql.org; Wed, 19 Sep 2018 08:35:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1537346097; bh=Ngqndvtjbo8F84jqlzN9LRykjQHP1VHZ7qQCmQd3yXA=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=CRYVtiPPGOtvuEe+6aOiR3y0KSNOx+6xJ/mnresdZ8il2GHTO22X4LVDF3gVO7zFNYfg+mwGrbz3QbNhSVXnPjX1oGAii3sXJvgWSfc6T8JGF7pzDQ4gWQ2AcYD6Pm0z/tkuv7WFqk2+xAbaFFKwVOvnifvttRUV+vvzm91UsNOykm09PuOnOEeQnfEq4cr4H735dzT7lAToBCPlN5YznF52vxfKVA1s86V6vp1PKx8hjWmn06ExjsTR4nOsHy2QXL/GVmDVqC2j4FHGBVQwz1sV4M7MNHyhovz3hdDkywhh8SwLq+5Mtf2g93YZyE/NU2xlT2CYsvWWmezMVAhkwA== X-YMail-OSG: dtTTzoYVM1lzc2EtuUTbSdCCj_Y9K4OzsIG75CLzu2ZuDEIttNyVFCDnp5B9hwf 76R2q2fEIzj82SNscavsJ8VUvvb8n9GQYaI9TAaSlyPUpbuyvm4crC1ELyejqExSQrjEjXR2fiDc YD7umcWVtnB4ju1DgabKwG526mHyNa4.q4GKP2AeEdei2qrRJizkjKG.daR0Wc87OpDrC7KRTPaR w0PRYOEowykxxrgmCmZlWa.dnSi6Jj3E8OunyPG.VPv6KaBl6cLfMzuDumfgGg9t.JGbxOHYh_GZ p5eBSfKDTXCDpm4atGSngUggtOBsqVjxw4fZ.GEIgX0RlraOPBLbttRoHAhtLVECHkbZAo.18PAj BguLLsqjA0btrAoC0LbVLZfP.KsoIJnPSj0Maos7V7tj2Yc.NdS2zY2IlubcuOCKdFoL8Gp71OX5 FglE8CU5Wr9RCa8eiIIs8.iWZp6nEDY2k7mc52uHipB6cOuquJzwp3BZqtc2vqnQQi44BT_Igt6m s3H6jTZym60XiJxoJYntbLJcvXJC3uvzhnocjBHxZNwyBt3Mbgw5QEEvlTjNyXRzEM67DajAbJXm TbmQVEkVgPOjlYAJLyTYFQCT.ypROyUmnEYsPQUWRmlzcPcrC9sp6CQTvA9DPUbmy6OYbvxVhPdr wI_1FxeVKx9leFdL5Tz7ow9tq9PLTEJLwdoHLYQORXNxHWCsLAXQ0LlTNMLt1Z8vx1RE7FFM_I30 RKGHL0s0doLoS25ab2XAANYmEmaA6u_huS.v66g35bmZLieHbcECyhLwfQfxSkez6SEI7IIi0ef0 gpxBgNEw6u.zk.Jhs_Oodztt4fmRnEvApuSve12K.h9BdoHANcOJ8F371ICj3.84U88iDdfy.zOT eBCch3mgUL0TnNdQYqXc3LY0F5BW3CkhhBjo6N9DnaSzGEJFLZine19Qqn3Bnsfiv.U12dEUq2TH HhhElDU2Lg.HvbA-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Wed, 19 Sep 2018 08:34:57 +0000 Date: Wed, 19 Sep 2018 08:30:49 +0000 (UTC) From: "Sam R." Reply-To: "Sam R." To: "pgsql-performance@lists.postgresql.org" Message-ID: <1101666388.6439182.1537345849495@mail.yahoo.com> Subject: How to see/calculate size of index in memory? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6439181_475358565.1537345849494" References: <1101666388.6439182.1537345849495.ref@mail.yahoo.com> X-Mailer: WebService/1.1.12406 YahooMailNeo Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0 Content-Length: 2156 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_6439181_475358565.1537345849494 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit 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 ------=_Part_6439181_475358565.1537345849494 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi!

I wou= ld have following question, if someone could help.

Ques= tion 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). Doe= s that tell size of index on disk?

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

PG10/PG11.

Best Regards, Sam

------=_Part_6439181_475358565.1537345849494--