From: | Dimitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: unorthodox use of PG for a customer |
Date: | 2018-08-24 19:20:08 |
Message-ID: | 4b416374-3da8-f713-a996-a398fa903d7f@bmrb.wisc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/24/2018 02:07 PM, David Gauthier wrote:
>
> ... He likes the idea of a
> separate DB per workarea. He just doesn't gt it.
Well there are advantages to that.
> But for some reason, he doesn't like
> the client/server DB model which would work so nicely here. I'm just
> trying to make sure I didn't miss some sort of solution, PG or not, that
> would work here.
What you should tell him is that he can't have it both ways. Either it's
multiple worker nodes concurrently writing to the same workstation -- in
which case he needs "a server" on the workstation to accept incoming
connections and all that overhead, with enough oomph to handle
concurrency he expects. Or it's a beefed-up central server where
everybody writes to, and every workstation can poll it and maintain its
own state databases from there (i.e. worker nodes don't talk back to
submit nodes).
--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Carlos Ericksson Richter | 2018-08-24 19:22:30 | Re: unorthodox use of PG for a customer |
Previous Message | Adrian Klaver | 2018-08-24 19:14:01 | Re: unorthodox use of PG for a customer |