Skip site navigation (1) Skip section navigation (2)

variable length - user defined types/storage place

From: martin(dot)bokler(at)web(dot)de
To: pgsql-performance(at)postgresql(dot)org
Subject: variable length - user defined types/storage place
Date: 2004-07-23 21:28:15
Message-ID: 41019F0F.10384.345001@localhost (view raw or flat)
Thread:
Lists: pgsql-performance
Hi all,

in a large table (millions of rows) I am using 
a variable-length user
defined type 
to store relatively short field entries, i.e. the 
length of certain
fields could be restricted to 2^16 or even 
2^8 characters.

Now I wonder whether it would be possible 
to save storage place, by
using a smaller length field, i.e. 2 Byte or 
even better 1 Byte per entry instead of 4 
Byte.

Is there a possibility to customize the size of 
the length field or does
Postgresql already internally optimize this?

Thanks in advance,
 Martin. 



pgsql-performance by date

Next:From: Jaime CasanovaDate: 2004-07-23 21:51:11
Subject: Re: [HACKERS] Wrong index choosen?
Previous:From: Matthew T. O'ConnorDate: 2004-07-23 18:12:09
Subject: Re: [HACKERS] Wrong index choosen?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group