Tom Lane wrote:
If you insist on crafting a solution that only fixes this problem for
pg_restore's narrow usage, you'll be back revisiting it before beta1
has been out a month.
I don't know much about what is involved in crafting these solutions,
but it seems we're close to beta and probably don't want to make drastic
changes to anything. As such it seems to me that solving the problem
for analyze is a nice piece of low-hanging fruit that solves an
immediate problem that has been reported. I would think that reducing
the locking implications of VACUUM is much more involved, no? Also, I
would think that the fix for ANALYZE will be totally different than the
fix for VACUUM no?
Are you proposing that we solve the VACUUM locking problem before we
release 8.3?
---------------------------(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
