Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "borajetta" <borajetta(at)hotmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
Date: 2004-06-15 00:11:43
Message-ID: 200406141711.43571.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Borajetta,

> So I have a table with about 50 million entries in it, I have to do a
keyword search.

Are you using OpenFTS/TSearch2? Is your database optimized?

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Marcus Whitney 2004-06-15 03:33:26 Re: Failed System. Help.
Previous Message ken 2004-06-14 23:47:08 Re: Index oddity (still)