Valerii Valeev <valerii.val...@mail.ru> wrote: > Dear colleagues, > > can anyone please explain, why we do not create indexes on master? > In my case master / child design blindly follows partitioning guide https:// > www.postgresql.org/docs/9.6/static/ddl-partitioning.html. > My collaborator was unhappy with performance of queries over master table with > filtering by one of fields > > SELECT * FROM “master" WHERE “field" BETWEEN x AND y > > (there are indexes for “field” on child tables). > He has created index on master once and found that the query returns 100x > faster.
please show us explain analyse with/without index on master. Regards, Andreas Kretschmer -- Andreas Kretschmer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
