Index on integer or on string field - Mailing list pgsql-general

From Job
Subject Index on integer or on string field
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A04F71C6F9B1E@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: Index on integer or on string field
Re: Index on integer or on string field
Re: Index on integer or on string field
List 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
performanceand reduce workload. 

The unique values, of that fields, are about the 50 (category name), and we could create a second table to codify, with
numericalinteger 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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade failing from 9.3 to 9.4 because "template0" already exists
Next
From: Arthur Silva
Date:
Subject: Re: Index on integer or on string field