Re: Scale out postgresql - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: Scale out postgresql
Date
Msg-id CA+t6e1m4H-P0s=s1Vthh6b4ePROxnkPQhLHUq3s0OC+aBnEM=Q@mail.gmail.com
Whole thread Raw
In response to Re: Scale out postgresql  ("Sam R." <samruohola@yahoo.com>)
Responses Re: Scale out postgresql
List pgsql-performance
Hey Sam,
Are you familiar with scale solutions that arent in the cloud ?

‫בתאריך יום ה׳, 28 במרץ 2019 ב-18:10 מאת ‪Sam R.‬‏ <‪samruohola@yahoo.com‬‏>:‬
Hi!

With following kinds of keywords, it is possible to find / search for cloud native (SQL) implementations e.g. with google: 

cloud native sql database

E.g. CockroachDB, YugaByteDB.

I do not know are you planning to do it by other means (by yourself).

I myself would be interested, has someone had experiences with such? Is HA provided "ready made? Is HA working fine and does it recover/handle all situations well, or is additional algorithms needed to be implemented in addition on top e.g. for automatic recovery (by "myself").

I could start an other email chain, if this chain is meant more for something else.

Best Regards
Sam


On to, maalisk. 28, 2019 at 12:10, Mariel Cherkassky
Hey,
I was searching for a solution to scale my postgresql instance in the cloud. I'm aware of that that I can create many read only replicas in the cloud and it would improve my reading performance. I wanted to hear what solution are you familiar with ? Are there any sharding solution that are commonly used (citus ? pg_shard ?) My instance has many dbs (one per customer) and big customers can generate a load of load on others..



Thanks.

pgsql-performance by date:

Previous
From: "Sam R."
Date:
Subject: Re: Scale out postgresql
Next
From: Sumedh Pathak
Date:
Subject: Re: Scale out postgresql