From: Franck Routier <franck.routier@axege.com>
To: pgsql-performance@postgresql.org
Subject: Does max size of varchar influence index size
Date: Mon, 30 Jun 2008 18:57:58 +0200
Message-ID: <1214845078.6710.7.camel@franck-laptop> (raw)
Hi,
I have problems with my database becoming huge in size (around 150 GB
right now, and 2/3 for only three tables, each having around 30 millions
tuples. Space is spent mainly on indices.).
I have a lot of multi-column varchar primary keys (natural keys), and
lot of foreign keys on these tables and thus a lot of indices.
When using VARCHAR, we defaulted to VARCHAR(32) (because on _some_ of
the identifiers, we have to apply md5).
We assumed that using VARCHAR(32) but having values at most 4 characters
long (for example) wouldn't influence indices size, ie it would be the
same as using VARCHAR(4) to keep the example.
Now I really doubt if we were right :)
So, what should we expect ? And are there other factors influencing
indices size ?
Thanks,
Franck
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: franck.routier@axege.com
Subject: Re: Does max size of varchar influence index size
In-Reply-To: <1214845078.6710.7.camel@franck-laptop>
* 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