Postgres Pro
Downloads
Home   >   mailing lists

Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED - Mailing list pgsql-performance

From Josh Berkus
Subject Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED
Date
Msg-id 200406141711.43571.josh@agliodbs.com
Whole thread Raw
In response to 50 000 000 Table entries and I have to do a keyword search HELP NEEDED  ("borajetta" <borajetta@hotmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: ken
Date:
Subject: Re: Index oddity (still)
Next
From: Marcus Whitney
Date:
Subject: Re: Failed System. Help.