Hello,
I am trying to determine if I can make the planner see that nested loop is
very expensive while it is trying to do an plan for a query and not pick that
route.
Is there a way to this in postgres? I know about the "set enable..."
commands. I was wondering if I can do it withou
Abu Mushayeed <[EMAIL PROTECTED]> writes:
> I am trying to determine if I can make the planner see that nested loop is
> very expensive while it is trying to do an plan for a query and not pick that
> route.
If it's doing that when it shouldn't, it's probably because it's
underestimated the n
My default_statistics_target in the postgresql.conf file is set at 250. The
tables are vacuumed everyday. Now, does that mean, for each column or only for
the column on which index exist, increase the value of "statistics" value, so
while analyzing it uses more rows in the sample.
Thanks
Ab
