You should probably experiment with a btree-gin index on those. Em 15/05/2015 12:22, "Job" <j...@colliniconsulting.it> escreveu:
> 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
