Re: Query performance PLEASE HELP - Mailing list pgsql-general

From Tom Lane
Subject Re: Query performance PLEASE HELP
Date
Msg-id 26055.1044047263@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query performance PLEASE HELP  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> Sorry, it was the same query as before - just had 'COMP%' instead of
> 'POST%':

Oh, I see.  How many tradestyle rows actually match "name like 'COMP%'"
and "name like 'POST%'" ?  The planner seems to be expecting very few.

            regards, tom lane

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: very basic question
Next
From: Luis Magaña
Date:
Subject: For each record in SELECT