Postgres Pro
Downloads
Home   >   mailing lists

Disk space consumption: character varying(255) versus text used forindex - Mailing list pgsql-novice

From Marcel Ruff
Subject Disk space consumption: character varying(255) versus text used forindex
Date
Msg-id 9db72137-fd67-9450-379d-2cb7b51a53c2@netwake.com
Whole thread Raw
Responses Re: Disk space consumption: character varying(255) versus text used for index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Justin
Date:
Subject: Re: Renaming sequences
Next
From: Tom Lane
Date:
Subject: Re: Disk space consumption: character varying(255) versus text used for index