Re: Query Analysis

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: typea(at)l-i-e(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query Analysis
Date: 2002-11-21 19:41:39
Message-ID: 13900.1037907699@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<typea(at)l-i-e(dot)com> writes:
> 15,000 reocrds with a 'text' field named 'text'
> Average 'text' length about 10 K.
> Full text search using lower() and LIKE and even ~* sometimes on that
> field with a keyword.

Consider using a full-text-indexing method (there are a couple in
contrib, and OpenFTS has a website that was mentioned recently in
the mail lists).

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Nielsen 2002-11-21 20:03:46 Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on
Previous Message scott.marlowe 2002-11-21 19:39:09 Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on