Path: csiph.com!aioe.org!.POSTED.6raoq1PyWk8qRCF8R7Yh/w.user.gioia.aioe.org!not-for-mail From: Pankaj Jangid Newsgroups: comp.databases.postgresql Subject: Re: Application architecture for multi-site manufacturing Date: Mon, 16 Sep 2019 02:02:01 +0530 Organization: Aioe.org NNTP Server Lines: 32 Message-ID: References: <877e69h1jg.fsf@x230.onfire.org> NNTP-Posting-Host: 6raoq1PyWk8qRCF8R7Yh/w.user.gioia.aioe.org Mime-Version: 1.0 Content-Type: text/plain X-Complaints-To: abuse@aioe.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.3 (darwin) X-Notice: Filtered by postfilter v. 0.9.2 Cancel-Lock: sha1:4svkwnn7KmC1tbYELuKh7EPnzVk= Xref: csiph.com comp.databases.postgresql:874 Christian Barthel writes: > I can not comment much on the above because I do not have a lot > of experience with designing de-central, big systems(*). I would > try to find a simple way of dealing with the existing demands and > improve the existing solution incrementally. Is a Redis cache > really necessary? If you have a local copy of the data on each > site, the performance of PostgreSQL may be good enough? Can you > add performance improvements later? Can you make it modular and > extendable for future demands etc. > This is a really practicle advice. Thanks. Given the timeline of this project I wanted some suggestion to deal with the complexity. And this is really a breather. I can certainly apply incremental improvement. > Apart from that, more experienced people might be available on > the mailinglist at https://lists.postgresql.org/. There is a lot > more conversation going on. > Yes. That would be more appropriate I also guess. > (*) It is more or less a reply to let you know that there is > at least one person who still reads this group. I really appreciate your reply. Felt so lonely after posting my query. Your reply is a hope. Regards. -- Pankaj Jangid