Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimising "in" queries - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Optimising "in" queries
Date
Msg-id 46CC3F22.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Optimising "in" queries  (Stephen Davies <scldad@sdc.com.au>)
List pgsql-performance
Tree view 
>>> On Tue, Aug 21, 2007 at  9:40 PM, in message
<200708221210.36770.scldad@sdc.com.au>, Stephen Davies <scldad@sdc.com.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

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Fast tsearch2, trigram matching on short phrases
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: Fast tsearch2, trigram matching on short phrases