Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiNB2-0004bq-GT for pgsql-novice@arkaria.postgresql.org; Fri, 20 Dec 2019 18:39:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iiNB0-0003pT-P7 for pgsql-novice@arkaria.postgresql.org; Fri, 20 Dec 2019 18:39:02 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiMrh-00057n-JK for pgsql-novice@lists.postgresql.org; Fri, 20 Dec 2019 18:19:05 +0000 Received: from intra.netwake.com ([88.198.43.220]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1iiMrb-00036P-WD for pgsql-novice@postgresql.org; Fri, 20 Dec 2019 18:19:04 +0000 Received: from localhost (localhost [127.0.0.1]) by NetwakeIntra (Postfix) with ESMTP id 415EDEC0B59; Fri, 20 Dec 2019 19:18:57 +0100 (CET) Received: from intra.netwake.com ([127.0.0.1]) by localhost (intra.netwake.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id MbEVlROgygeu; Fri, 20 Dec 2019 19:18:55 +0100 (CET) Received: from [192.168.1.10] (unknown [37.49.124.28]) (Authenticated sender: marcel) by NetwakeIntra (Postfix) with ESMTPSA id 37717EC0911; Fri, 20 Dec 2019 19:18:55 +0100 (CET) Reply-To: ruff@netwake.com To: pgsql-novice@postgresql.org From: Marcel Ruff Subject: Disk space consumption: character varying(255) versus text used for index Autocrypt: addr=ruff@netwake.com; prefer-encrypt=mutual; keydata= xsBNBFH/V6UBCADD9VLg3fyiWTMVM+1+GwKY9bLJfEv9bQKBwpEPD0JLUUUx0JUspCz8H1QW AjRscJQY4d4Ri4VTGV66dUArwmouxHGEmy0mU/PXfebL5aYS610hddYBLmqLlEs1jJVJik4m oniJYNzW773t4b1JR0L+w6yT3jamsy7/fsfUWOCWaukFlWwb1S8hLzk9Bx6JUvhbJjY/1D1H oipKfxRS0XoFwXMTON+KNX5uOpVg4ufZcJnQSEyr7tIzOOi9bpyjfJy2QqStdfwwTHLouCBY qC2mUhK2lLyeek21p+WgF3B2jwGMYo4fz/IYjqlDitjdzG7cb7iWC8balWIjOfDEjZpdABEB AAHNHk1hcmNlbCBSdWZmIDxydWZmQG5ldHdha2UuY29tPsLArQQTAQIAQAIbIwcLCQgHAwIB BhUIAgkKCwQWAgMBAh4BAheAFiEEXz5kvTCLE6HDsIffNFVc+q426lYFAlxRyJYFCRO4cnEA IQkQNFVc+q426lYWIQRfPmS9MIsTocOwh980VVz6rjbqVpfKB/4uy6T30Ua8vAkbEoTuPtIU 4IvIrRpbWMfktv3BQyJWR9vSOdn/HJHNiJZcKs0DXk+37mW8enxrePnVUmZpbi6rb8vWARmL ezJvoasTbB9CmlKKf9jxIiB0Yjbz57FmEUZ1StwGpXZ2QSWx+gb95st51tk0ccOxc8m3y4Sz 3xhYxsaYdUOlHpPLp51bv4jfOEky9U2djElxCgDZpV24lrtFacGCwkhYG8PVWVxmJpkVgr8B lXjMGB9VtKUo0L73RKZRkbevhliVk/zC21SzImnjyoFkx2fkzXPRr2H3mpugkzWUJjPlB7bB 45jiykU5K/eroE76wZU/IN3OqPWUknrNzsBNBFH/V6UBCACvdgYfN1WRBl22JT9gxBFDTjDR GuqH8Y05oKMecw84MCo1UB2/ZywRA+hYjfh7ROSDAGOrLYNJH+BvjQw/uiVTkTdPoHhWAMZK 1X00twT3fIOf9G7gG+Qbo56QIzQGVnUsXM3414ODW1s+mmSsfzvaH+I+PywnoyMmIXsMI6d7 Stu2wr1OjvH+oWrv/PfO7db1ITPLOsjx8QtbjmMOkDoXIK3s67KCAXBwtLSQ0c+GDnPoFOFd MGFQjGrhxceOqfOjv1wyem8LK9iiHz+Evf/Sz07kkGWB5AHplM09TjVVniQbpE+IDBDZs+pH 2uJHDrVTxQvRn9S82Xd0wjCbRuPPABEBAAHCwI0EGAECACACGwwWIQRfPmS9MIsTocOwh980 VVz6rjbqVgUCW3UtnwAhCRA0VVz6rjbqVhYhBF8+ZL0wixOhw7CH3zRVXPquNupWPfYH/26x Z2j0u0DjczbHJD+19UzoKGhjx8+9+lYRfkTgnU9ZsYyugG56A0EMiFlZL4JmPqFbqPQLuFSM IkaKuigf9YYtF4y1cRxVdXkVHJ3dujvJRz4eBs72a4c6M0yC5k3C3rS6pk8yLkiY4M9JVtb5 gcPUozQqi2lhEyfrFeBfdteBWPi5qxh8XBN0lQHuewHex+45Gd7roZtnQzlLjxWQEqTjAgdj gnBXJvU72lYtLptw5XNp+xAdjqFB4s2B4bfbxTlVkYT/0Srtj8zs5586jKQh6aAyw+mXpm/O 68k1iQXvKWCdpeFSfCrRt7ajDXThgPkdP2DW9wVJHS0uhujESms= Organization: Netwake GmbH Message-ID: <9db72137-fd67-9450-379d-2cb7b51a53c2@netwake.com> Date: Fri, 20 Dec 2019 19:18:45 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.2.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------C3AA281FCA8E7487F8711950" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 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--