Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    84

    Red face Unanswered: performance of postgresql

    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
    this scenario?

    thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    ok

    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •