From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: views and fdw usage and performance |
Date: | 2017-05-10 04:13:17 |
Message-ID: | 62209665-807a-95ab-9c56-fa7c010ec3ba@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/09/2017 07:03 PM, Armand Pirvu (home) wrote:
>
> On May 9, 2017, at 7:11 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> On 05/09/2017 05:02 PM, armand pirvu wrote:
>>> Well
>>> Jt1 is prod and jt2 is dev
>>
>> You are talking schemas, not databases, correct?
>>
>>
>
> Correct
>
>>> Before someone pushes to prod it does work in dev. The jdbc connection
>>
>> That would concern me, as anything bad that happened in the dev schema could bring the entire database to its knees, including the prod schema.
>>
>> How does data get into the prod schema if the connection is to the dev schema?
>
> If you are a user in say category B you get to dev where you do your thing. If you deem okay you push to prod.
> If you are a user in say category A you get to prod
>
>
>
>>
>>> routes to jt2. In the mean time it wad needed that some tables in prod are synced at all times from dev. Hence the view/fdw.
>>> What I meant by connections was more to say the type of load or users doing something in each schema.
>>
>> The issue being that if you are pushing data from jt2 --> jt1 you are also pushing the load in the same direction.
>
> I see but short of using something like Slony in between the two schemas I don’t see a pretty simple choice
Create a separate dev database or cluster?
>
>
>>
>>> So my questions still remain
>
> And about the plan from the fdw am I right or wrong ? I am inclined to say I am right based on the numbers in the timings
The timings where for a simple select. I am going to say doing something
that INSERTs/UPDATEs is going to be different. Still since a FDW
involves establishing another connection and passing data across it I
would say it is going to be less efficient.
>
>
>>> Sent from my iPhone
>>> On May 9, 2017, at 6:52 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dick Kniep | 2017-05-10 07:46:15 | Re: Python versus Other Languages using PostgreSQL |
Previous Message | Fabrízio de Royes Mello | 2017-05-10 03:05:13 | Re: Convert from LATIN9 to UTF-8 / WAL Replication |