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

2016-12-27 Thread Valerii Valeev
David, thanks a lot for the comments and for clarity. As I already responded to Andreas, I’m going to get some test data and try to investigate myself. Thought maybe I’m missing some common knowledge, that’s why asked here before taking deeper look. Regards, Val. > On Dec 27 2016, at 20:48,

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

2016-12-27 Thread David G. Johnston
On Tue, Dec 27, 2016 at 10:38 AM, Valerii Valeev wrote: > Thank you David, > > I used same rationale to convince my colleague — it didn’t work :) > Sort of “pragmatic” person who does what seems working no matter what > happens tomorrow. > So I’m seeking for better

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

2016-12-27 Thread ProPAAS DBA
Possibly some buffer caching is happening, what happens if you then remove the added index and run the query again? On 12/27/2016 10:38 AM, Valerii Valeev wrote: Thank you David, I used same rationale to convince my colleague — it didn’t work :) Sort of “pragmatic” person who does what

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

2016-12-27 Thread Valerii Valeev
Thank you David, I used same rationale to convince my colleague — it didn’t work :) Sort of “pragmatic” person who does what seems working no matter what happens tomorrow. So I’m seeking for better understanding of what's happening to have other cause to convince him. Let me break it down once

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

2016-12-27 Thread David G. Johnston
On Tue, Dec 27, 2016 at 8:22 AM, Valerii Valeev wrote: > I have naive idea that it won’t help if index is created before the data > is there — i.e. indexes on master aren’t updated when data loaded to child > table. > ​Indexes on the master table of a partition scheme

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

2016-12-27 Thread Andreas Kretschmer
Valerii Valeev 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

[PERFORM] why we do not create indexes on master

2016-12-27 Thread Valerii Valeev
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