| From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
|---|---|
| To: | Armand Turpel <aturpel(at)mnhn(dot)lu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | R: index or not |
| Date: | 2010-05-15 14:25:46 |
| Message-ID: | AANLkTikAKdlYtIWfXNXIobBnwqmjWTeJ4Ww6ijjI9poN@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
It strongly depends from the queries. Usually yes
Il giorno 2010 5 15 16:20, "Armand Turpel" <aturpel(at)mnhn(dot)lu> ha scritto:
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.
#####################################################################################
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julian Mehnle | 2010-05-15 16:14:32 | Re: "--variable foo=bar" vs. "\set foo quux" in ~/.psqlrc |
| Previous Message | Armand Turpel | 2010-05-15 14:03:01 | index or not |