On Thursday 08 May 2008, Rauan Maemirov <rauan1987@gmail.com> wrote:
> Hi, all. I want to ask what type of index is better to create for
> bigint types. I have table with bigint (bigserial) primary key. What
> type is better to use for it? I tried btree and hash, but didn't
> notice any differences in execution time.

A primary key is a unique btree index, and it's as about as good as it gets
for a bigint.

--
Alan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBII1oBJmf5OzX07HQRAmIKAJ9nxB9wGstt5zKbB+ff6p ryuTFQ8QCfaPdB
MwQsTwy5d/FjezcAJDGjaZo=
=/Vqe
-----END PGP SIGNATURE-----