Re: Built-in Raft replication - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Built-in Raft replication
Date
Msg-id CAKAnmm+QJnL_APyKhM3hjkOv9DXjWaqJxB2nFDuNH9JqVdTfXA@mail.gmail.com
Whole thread Raw
In response to Re: Built-in Raft replication  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Responses Re: Built-in Raft replication
Re: Built-in Raft replication
List pgsql-hackers
On Wed, Apr 16, 2025 at 2:18 AM Ashutosh Bapat <ashutosh.bapat.oss@gmail.com> wrote:
Users find it a waste of resources to deploy 3 big PostgreSQL instances just for HA where 2 suffice even if they deploy 3 lightweight DCS instances. Having only some of the nodes act as DCS and others purely PostgreSQL nodes will reduce waste of resources.

A big problem is that putting your DCS into Postgres means your whole system is now super-sensitive to IO/WAL-streaming issues, and a busy database doing database stuff is going to start affecting the DCS stuff.  With three lightweight DCS servers, you don't really need to worry about how stressed the database servers are. In that way, I feel etcd et al. are adhering to the unix philosophy of "do one thing, and do it well."

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance issues with v18 SQL-language-function changes
Next
From: Konstantin Osipov
Date:
Subject: Re: Built-in Raft replication