public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marcel Ruff <[email protected]>
To: Stephen Froehlich <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Disk space consumption: character varying(255) versus text used for index
Date: Sat, 21 Dec 2019 18:09:58 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <DM6PR06MB488956DEB11A82EFC5DFEF91E52C0@DM6PR06MB4889.namprd06.prod.outlook.com>
References: <[email protected]>
<[email protected]>
<CALL-XeOFZ0sFuYFk-KLBhBu8DmArFkkKvPRXFwE5GisN04GBMA@mail.gmail.com>
<DM6PR06MB488956DEB11A82EFC5DFEF91E52C0@DM6PR06MB4889.namprd06.prod.outlook.com>
Thank you for the hints, this helps a lot.
I love PostgreSQL,
Marcel
Am 21.12.19 um 15:41 schrieb Stephen Froehlich:
>
> Just to make it a little more clear, PostgreSQL has a binary UUID type
> that should house your GUID’s perfectly efficiently. (It also provides
> a lot of other useful functionality and speed improvements):
>
>
>
> https://www.postgresql.org/docs/12/datatype-uuid.html
>
>
>
>
>
>
>
> *From:* Justin <[email protected]>
> *Sent:* Friday, December 20, 2019 12:06 PM
> *To:* Tom Lane <[email protected]>
> *Cc:* [email protected]; [email protected]
> *Subject:* Re: Disk space consumption: character varying(255) versus
> text used for index
>
>
>
> Have question this states the GUID is the text Hex value form a UUID
> if so that 36bytes long vs integer that is 128bits if that is the
> case convert this GUID to UUID type
>
>
>
> or am i missing something?
>
>
>
> On Fri, Dec 20, 2019 at 1:55 PM Tom Lane <[email protected]
> <mailto:[email protected]>> wrote:
>
> Marcel Ruff <[email protected] <mailto:[email protected]>> writes:
> > 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)?
>
> Wouldn't make any difference at all.
>
> regards, tom lane
>
--
NetwakeVision
Alte Owinger Straße 100
D-88662 Überlingen
Phone: +49 7551 309372
http://www.netwakevision.com
http://www.royal-gps.com
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Disk space consumption: character varying(255) versus text used for index
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox