Josh Berkus <> writes:
> As you can see, n_distinct estimation is off by a factor of 10x and it's 
> causing query planning problems.   Any suggested hacks to improve the 
> histogram on this?

What's the histogram itself look like?  (I'd like to see the whole
pg_stats row not just part of it ...)  There's probably no point in
showing the target=1000 version, but maybe target=100 would be

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to