Istvan Endredy <istvan(dot)endredy(at)gmail(dot)com> wrote:
> i've ran into a planning problem.
> If effective_cache_size has a greater value (6GB), this select has
> a bad planning and long query time (2000ms):
Could you try that configuration with one change and let us know how
it goes?:
set cpu_tuple_cost = '0.05';
I've seen an awful lot of queries benefit from a higher value for
that setting, and I'm starting to think a change to that default is
in order.
-Kevin