All Questions
Tagged with inheritance postgresql-9.5
4 questions
0
votes
0
answers
111
views
Poor performance in a SELECT using Inheritance
I will detail my problem in good detail. I have a marketplace application so I make a decision to make a multitenant per schema approach. I like this approach because of the isolation of data, but I'm ...
- 101
1
vote
1
answer
5k
views
PostgreSQL: Multiple Inheritance tables (one child to two parents)
If I have a base table and 2 or more tables that inherit from it, child1 and child2, I can insert a record into a child table and it shows up in base as you would expect.
However what I want to know ...
- 131
2
votes
2
answers
4k
views
Postgres inherit from one role and not another
I'm a little new with postgres but have a decent understanding of roles. What I have are users that inherit from their normal "data_analyst" group. This group is used to manage all data analyst users ...
- 83
3
votes
1
answer
4k
views
Postgres 9.5 foreign table inheritance not using indexes
In PostgreSQL 9.5.0 I have a partitioned table that collects data by months. I tried to use the new PostgreSQL feature of foreign table inheritance and pushed one month of data to another PostgreSQL ...
