On Fri, May 15, 2015 at 9:18 AM, Job <Job@xxxxxxxxxxxxxxxxxxxx> wrote: > 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? Have you considered using a multi-column index here? if there's a more selective field you could index along with your rather non-selective one that might work better. But it's hard to tell without looking at you database usage etc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
