2009/8/18 Slava Moudry <smoudry(at)4info(dot)net>:
>> increase default stats target, analyze, try again.
> This field has only 5 values. I had put values/frequencies in my first post.
Sorry, kinda missed that. Anyway, there's no way for pg to know which
operation is gonna match. Without an index on it. So my guess is
that it just guesses some fixed value. With an index it might be able
to get it right, but you'll need an index for each type of match
you're looking for. I think. Maybe someone else on the list has a
In response to
pgsql-performance by date
|Next:||From: Karl Denninger||Date: 2009-08-18 23:03:44|
|Subject: Re: SQL Query Performance - what gives?|
|Previous:||From: Slava Moudry||Date: 2009-08-18 22:11:20|
|Subject: Re: number of rows estimation for bit-AND operation|