Re: [PERFORM] why we do not create indexes on master

:48, David G. Johnston > wrote: > > On Tue, Dec 27, 2016 at 10:38 AM, Valerii Valeev <mailto:valerii.val...@mail.ru>> wrote: > Thank you David, > > I used same rationale to convince my colleague — it didn’t work :) > Sort of “pragmatic” person who does what see

[PERFORM] Fwd: [pgsql-performance] Daily digest v1.4804 (8 messages)

and come back after that. Regards, Val. > From: Andreas Kretschmer <mailto:akretsch...@spamfence.net>> > Subject: Re: why we do not create indexes on master > Date: Dec 27 2016 19:04:27 GMT+3 > To: pgsql-performance@postgresql.org <mailto:pgsql-performance@postgresql.org

Re: [PERFORM] why we do not create indexes on master

inserting record to child tables will not take into account this record? - Q3: are there any other bad sides of indexes on master table? Regards, Val. > On Dec 27 2016, at 19:19, David G. Johnston > wrote: > > On Tue, Dec 27, 2016 at 8:22 AM, Valerii Valeev <mailto:valerii.va

[PERFORM] why we do not create indexes on master

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 collabor