Mastering PostgreSQL Administration [pdf]

Post by 101008 » Sun, Sep 27, 2020, 6:23 PM UTC

Nextgrid wrote: post #7

christophilus wrote: post #2

I debated running my own Postgres cluster for a side project, but ended up paying for Digitalocean’s managed offering. I’d like to hear from anyone running their own Postgres. Why did you choose to do that vs pay for a managed instance? How much of a hassle has it been? Is it something you really need significant Postgres experience to do well (to achieve security, backups, high availability, etc)? Biggest gotchas to…

Most managed offerings run on virtual machines where performance is 1/10th of what you'd get on a bare-metal machine rented for the same cost. As an example, I'm currently working on a project where we have an Azure managed Postgres DB for a staging environment. It costs ~50$/month and is an order of magnitude slower than my entry-level MacBook. That amount of money would give you fast NVME storage, 8 core dedicated…

Post by pk78 » Sun, Sep 27, 2020, 6:32 PM UTC

Nextgrid wrote: post #20

pk78 wrote: post #19

Earlier quoted context omitted.

First time I'm hearing about soyoustart. I've been under the assumption that Linode's instances are the cheapest ones, but the one you linked is Can you share your experience with using soyoustart?

SYS is basically OVH’s lower-end offering that still provides SLAs and better bandwidth (they have an even cheaper offering called Kimsufi but no SLA on those - though great value for staging/non-critical systems). The experience is mostly solid, though they don’t provide any kind of console access and I once got locked out after putting a machine to sleep from the command line (and had to open a ticket for someone t…

Post by 101008 » Sun, Sep 27, 2020, 6:35 PM UTC

Nextgrid wrote: post #22

101008 wrote: post #21

Earlier quoted context omitted.

Yeah, Azure managed Postgres DB is slow. Using on a producton server right now and thinking to move to a VM, but it qoul reqeuire a lot of DB admin that we are not capable of (human resources, basically). My question: Is out there any other PostreSQL managed service faster than Azure and as simple to set up?

This worries me because I assumed the lower tier that I'm using right now (it's a staging environment) for that project is slow because it's the lowest tier but performance would improve significantly once we upgrade to the production-grade tiers. If that is not the case then I'm in trouble. I write and benchmark applications on my own laptop and always assume that if my low-end laptop is fast enough then whatever pr…

Post by gketuma » Sun, Sep 27, 2020, 6:35 PM UTC

krnaveen14 wrote: post #17

christophilus wrote: post #2

I debated running my own Postgres cluster for a side project, but ended up paying for Digitalocean’s managed offering. I’d like to hear from anyone running their own Postgres. Why did you choose to do that vs pay for a managed instance? How much of a hassle has it been? Is it something you really need significant Postgres experience to do well (to achieve security, backups, high availability, etc)? Biggest gotchas to…

Our product offers near real time (incremental sync every 3 mins) backup and restore solution for on-premise SQLServer data. We have used PostgreSQL to store the backup data in cloud and offered add-on services on top of PostgreSQL data (such as reports, analytics, etc). Every customer data is stored as a separate database. Initially we have used RDS as PostgreSQL instance when the product is in pilot phase. RDS cost…

Post by Nextgrid » Sun, Sep 27, 2020, 6:43 PM UTC

101008 wrote: post #25

Nextgrid wrote: post #22

Earlier quoted context omitted.

This worries me because I assumed the lower tier that I'm using right now (it's a staging environment) for that project is slow because it's the lowest tier but performance would improve significantly once we upgrade to the production-grade tiers. If that is not the case then I'm in trouble. I write and benchmark applications on my own laptop and always assume that if my low-end laptop is fast enough then whatever pr…

Sorry, I misworded. We are using it on "production", but our production is a closed beta for now, so we are using the Basic tier too. We are thinking in upgrade it to a better plan, but we are not sure because we are not sure that it will solve our problems. I think that comparing to your own laptop is unfair because there is no connectino needed, everything is on the same CPU / RAM, etc. Remember when you connect to…