On Fri, 4 Jan 2019 at 04:39, Justin Pryzby <pry...@telsasoft.com> wrote: > Running 11dev with your v10 patch applied, this takes 2244ms with empty buffer > cache after postmaster restarted on a totally untuned instance (and a new > backend, with no cached opened files). > > I was curious why it took even 2sec, and why it did so many opens() (but not > 20k of them that PG11 does):
It would be pretty hard to know that without seeing the query plan. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
