Disk space consumption: character varying(255) versus text used for index

Marcel Ruff <[email protected]> Fri, 20 Dec 2019 19:18:45 +0100

Newsgroups	gmane.comp.db.postgresql.novice
Organization	Netwake GmbH
Message-ID	<[email protected]>

This is a multi-part message in MIME format.
--------------C3AA281FCA8E7487F8711950
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

Hi,

my btree index for

   guid                | character varying(255)

is currently 6.9GB (almost all guid entries are of size 37bytes)

If I would change the data type to

  guid                | text

would the index size be reduced (without hitting performance)?

thank you
Marcel


-- 
NetwakeVision
Alte Owinger Straße 100
D-88662 Überlingen
Phone: +49 7551 309372
http://www.netwakevision.com
http://www.royal-gps.com

--------------C3AA281FCA8E7487F8711950
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi,<br>
    <br>
    my btree index for<br>
    <br>
       guid                | character varying(255)<br>
    <br>
    is currently 6.9GB (almost all guid entries are of size 37bytes)<br>
    <br>
    If I would change the data type to<br>
    <br>
      guid                | text<br>
    <br>
    would the index size be reduced (without hitting performance)?<br>
    <br>
    thank you<br>
    Marcel<br>
    <br>
    <br>
    <div class="moz-signature">-- <br>
      Netwake<font color="#e66f24">Vision</font><br>
      Alte Owinger Straße 100<br>
      D-88662 Überlingen<br>
      Phone: +49 7551 309372<br>
      <a class="moz-txt-link-freetext" href="http://www.netwakevision.com">http://www.netwakevision.com</a><br>
      <a class="moz-txt-link-freetext" href="http://www.royal-gps.com">http://www.royal-gps.com</a></div>
  </body>
</html>

--------------C3AA281FCA8E7487F8711950--