pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: martin.bokler@web.de
To: pgsql-performance@postgresql.org
Subject: variable length - user defined types/storage place
Date: Fri, 23 Jul 2004 23:28:15 +0200
Message-ID: <41019F0F.10384.345001@localhost> (raw)

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. 





Message-ID: <41019F0F.10384.345001@localhost>
Permalink:  ../41019F0F.10384.345001@localhost/
Also on:    postgresql.org/message-id/41019F0F.10384.345001@localhost

 · 

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: pgsql-performance@postgresql.org
  Cc: martin.bokler@web.de
  Subject: Re: variable length - user defined types/storage place
  In-Reply-To: <41019F0F.10384.345001@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox