Re: query efficiency - Can I speed it up?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org, ann hedley <ann(dot)hedley(at)ed(dot)ac(dot)uk>, Duncan Garland <duncan(dot)garland(at)ntlworld(dot)com>
Subject: Re: query efficiency - Can I speed it up?
Date: 2007-02-01 18:28:56
Message-ID: 20340.1170354536@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> writes:
> You might think about full-text searching of the descriptions. It may be
> quite a bit faster than a "like" search. It may be worth looking.

It's not the LIKE search that's her problem though --- the time is going
into fetching the matching rows from the other table.

If the "go" table becomes large then it'd be time to worry about that,
but right now it's only costing her 80 msec to seqscan it...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2007-02-01 18:29:56 Re: query efficiency - Can I speed it up?
Previous Message joe speigle 2007-02-01 18:04:02 fetch cursor into id, set_values .... -> problem