Postgres Pro
Downloads
Home   >   mailing lists

b-tree index performance - Mailing list pgsql-general

From Yonatan Ben-Nes
Subject b-tree index performance
Date
Msg-id 2d0127b80612150313k643201c6k669ab1cf80a08d89@mail.gmail.com
Whole thread Raw
Responses Re: b-tree index performance
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Henrik Zagerholm
Date:
Subject: Needed files - embedded postgres
Next
From: Martijn van Oosterhout
Date:
Subject: Re: b-tree index performance