b-tree index performance

From: "Yonatan Ben-Nes" <yonatan(at)epoch(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: b-tree index performance
Date: 2006-12-15 11:13:00
Message-ID: 2d0127b80612150313k643201c6k669ab1cf80a08d89@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I was wondering does the b-tree index performance change when it's
implemented on different data types fields? is it better to use one of them
instead of the other for (=) comparisons?
I'm especially interested between INT8 and TEXT data types.

Thanks a lot in advance,
Ben-Nes Yonatan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-12-15 11:41:09 Re: b-tree index performance
Previous Message Henrik Zagerholm 2006-12-15 10:41:39 Needed files - embedded postgres