From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: why we do not create indexes on master |
Date: | 2016-12-27 16:04:27 |
Message-ID: | 20161227160427.GA2843@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Valerii Valeev <valerii(dot)valeev(at)mail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-12-27 16:19:37 | Re: why we do not create indexes on master |
Previous Message | Valerii Valeev | 2016-12-27 15:22:13 | why we do not create indexes on master |