Re: Optimising "in" queries

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>, "Stephen Davies" <scldad(at)sdc(dot)com(dot)au>
Subject: Re: Optimising "in" queries
Date: 2007-08-22 18:50:26
Message-ID: 46CC3F22.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> On Tue, Aug 21, 2007 at 9:40 PM, in message
<200708221210(dot)36770(dot)scldad(at)sdc(dot)com(dot)au>, Stephen Davies <scldad(at)sdc(dot)com(dot)au>
wrote:
> Is there any way to make the "larger" queries more efficient?

People would be in a better position to answer that if you posted the table
structure and the results of EXPLAIN ANALYZE (rather than just EXPLAIN).

-Kevin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2007-08-22 20:25:16 Re: Fast tsearch2, trigram matching on short phrases
Previous Message Oleg Bartunov 2007-08-22 18:48:44 Re: Fast tsearch2, trigram matching on short phrases