"Marko Kreen" <markokr@xxxxxxxxx> writes:
> Note that it's much better to err on the smaller values.
> Extra index pass is really no problem.
I beg to differ ...
What this may actually suggest is that autovacuum needs its own value of
"maintenance_work_mem", or that it should automatically divide the value
by the authorized number of workers.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
