Performance with different index types

From: Johann Uhrmann <johann(dot)uhrmann(at)xpecto(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance with different index types
Date: 2003-08-18 09:48:13
Message-ID: 3F40A0DD.50604@xpecto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

are there any experiences about the performance of indices
with different data types.

How do the performance of an index that consists of

- an integer field
- a varchar() field
- a text field

differ?

Is it a waste of memory/performance to make a text field
primary key?

Thanks,

Hans

Responses

Browse pgsql-general by date

  From Date Subject
Next Message psql-mail 2003-08-18 09:59:15 Bit String Manipulation
Previous Message Hervé Piedvache 2003-08-18 08:20:13 Why lower's not accept an AS declaration ?