i need a database to cater for a large table. e.g. there is a keyword
field in the product table, which can have millions of records. the
length of the keyword file is 4000 characters. a fuzzy search (e.g.
using like clause) is needed on the keyword field.
i believe creating index on the keyword filed should be something
necessary. anything else that can improve the performance?
any expert can advise whether postgresql is actually a good choice for