index or not

From: Armand Turpel <aturpel(at)mnhn(dot)lu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: index or not
Date: 2010-05-15 14:03:01
Message-ID: 4BEEA995.5020209@mnhn.lu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
Does it make sense to create indexes on a table which only contains
bigint fields? Is there any performance gain?

Example:

Table x_rel
id_a bigint
id_b bigint
id_c bigint
id_d bigint

Thanks for replying,
Armand

#####################################################################################
Scanned by MailMarshal - Marshal's comprehensive email content security solution.
#####################################################################################

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2010-05-15 14:25:46 R: index or not
Previous Message Rob Wultsch 2010-05-15 13:37:12 Re: List traffic