Skip site navigation (1) Skip section navigation (2)

Improving simple textsearch?

From: Fabian Kreitner <fabian(dot)kreitner(at)ainea-ag(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Improving simple textsearch?
Date: 2003-08-27 14:36:14
Message-ID: 5.1.0.14.0.20030827162734.03b77c58@195.145.148.245 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Hi,

can anyone point me to information regarding this please?

Objective is to find entries that match one (or more) supplied strings in 
two tables. The first has about 20.000 entries with 1 varchar field to 
check, the other about 40.000 with 5 varchar fields to check. The currently 
used sequential scan is getting too expensive.

Thanks,
   Fabian


In response to

pgsql-performance by date

Next:From: mattDate: 2003-08-27 14:37:14
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Bill MoranDate: 2003-08-27 14:17:46
Subject: Re: Hardware recommendations to scale to silly load

pgsql-hackers by date

Next:From: mattDate: 2003-08-27 14:37:14
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Vivek KheraDate: 2003-08-27 14:22:02
Subject: Re: Buglist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group