Search Postgresql Archives

b-tree index performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: b-tree index performance
From: "Yonatan Ben-Nes" <yonatan@xxxxxxxxxxx>
Date: Fri, 15 Dec 2006 13:13:00 +0200

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: b-tree index performance
  - From: Martijn van Oosterhout

Prev by Date: Needed files - embedded postgres
Next by Date: Re: b-tree index performance
Previous by thread: Needed files - embedded postgres
Next by thread: Re: b-tree index performance
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux