On Fri, May 15, 2015 at 9:18 AM, Job <j...@colliniconsulting.it> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
