Alvaro Herrera wrote: > I think your argument is sensible for some uses (where people run manual > VACUUM after loading data) but not others (where people just use manual > VACUUM in place of autovacuuming -- because they don't trust autovac, or > the schedule isn't convenient, or whatever other reason). I've seen > both things being done in production.
BTW I also noticed that creating an index does summarize the first range (rather than leaving it empty, as this rationale would suggest). I think we changed this at the last minute before commit in 9.5 and never revisited; I'm inclined to change it for pg11 (but not now, of course). -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers