Performance with different index types - Mailing list pgsql-general

From Johann Uhrmann
Subject Performance with different index types
Date
Msg-id 3F40A0DD.50604@xpecto.com
Whole thread Raw
Responses Re: Performance with different index types  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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


pgsql-general by date:

Previous
From: Hervé Piedvache
Date:
Subject: Why lower's not accept an AS declaration ?
Next
From: psql-mail@freeuk.com
Date:
Subject: Bit String Manipulation