| From: | Job <Job(at)colliniconsulting(dot)it> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Index on integer or on string field |
| Date: | 2015-05-15 15:18:30 |
| Message-ID: | 88EF58F000EC4B4684700C2AA3A73D7A04F71C6F9B1E@W2008DC01.ColliniConsulting.lan |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
i have a table of about 10 millions of records, with the index on a string field.
Actually is alphabetical; since queries are about 100/200 per seconds, i was looking for a better way to improve performance and reduce workload.
The unique values, of that fields, are about the 50 (category name), and we could create a second table to codify, with numerical integer values, the 50 recurring names.
Is index are integer and not characteral, performance are better and workload reduces?
Is there any comparisons?
Thank you!
Francesco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arthur Silva | 2015-05-15 15:26:58 | Re: Index on integer or on string field |
| Previous Message | Bruce Momjian | 2015-05-15 14:51:15 | Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists |