On Fri, 4 Jan 2019 at 01:57, Abadie Lana <lana.aba...@iter.org> wrote: > 4) name is unique, constraint and index created. Right index is picked up and > query time is rather constant there 40sec.
That's surprisingly slow. Can you share the EXPLAIN (ANALYZE, BUFFERS) of that? -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
