Re: unorthodox use of PG for a customer - Mailing list pgsql-general

From Dimitri Maziuk
Subject Re: unorthodox use of PG for a customer
Date
Msg-id 4a7fa8d9-46c2-2ffe-1fd7-fde958603ad2@bmrb.wisc.edu
Whole thread Raw
In response to Re: unorthodox use of PG for a customer  (Andrew Kerber <andrew.kerber@gmail.com>)
List pgsql-general
On 08/24/2018 02:35 PM, Andrew Kerber wrote:
> Unless I am missing something, it sounds like you might be able to do this
> with an nfs export shared to each workstation.

That's no different from polling the central database though, you're
just using nfs server and files instead of a db server and queries.

A compute cluster has to have a manager node that has all the state. The
way to do what he wants is to query that manager from each workstation
and keep the results in the local state database. Whether that is
actually feasible/doable in his particular case is another question.

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu


Attachment

pgsql-general by date:

Previous
From: Andrew Kerber
Date:
Subject: Re: unorthodox use of PG for a customer
Next
From: Mark Jeffcoat
Date:
Subject: Re: Join condition parsing puzzle