Re: Postgres Architecture - Mailing list pgsql-hackers

From Timothy Nelson
Subject Re: Postgres Architecture
Date
Msg-id CANZ4r3adKd=rFsf+aHSun02JFauLGvdF5Z3O0EXKJc2pzoN5hQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Architecture  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: Postgres Architecture
Re: Postgres Architecture
List pgsql-hackers
Great!  I'm not surprised it's been around a long time -- I didn't think I could be the only one to think of it.  

Thanks for the heads-up on Postgres-XL -- I'd missed that one somehow. 

I'm going to include the words "architecture" and "replication" so that people searching the archives in the future have more chance of finding this conversation. 

Thanks! 

On Tue, 17 Oct 2023 at 02:07, Jonah H. Harris <jonah.harris@gmail.com> wrote:
On Mon, Oct 16, 2023 at 6:42 AM Timothy Nelson <wayland@wayland.id.au> wrote:
I'm expecting that people will pick the idea apart, and wanted to know what people think of it. 

Thanks for the proposal. This is actually a model that's been around for a very long time. And, in fact, variations of it (e.g. parsing done in one place and generated plan fragments shipped to remote execution nodes where the data resides) are already used by things like Postgres-XL. There have also been a number of academic implementations where parsing is done locally and raw parse trees are sent to the server as well. While these things do reduce CPU, there are a number of negative aspects to deal with that make such an architecture more difficult to manage.

--
Jonah H. Harris

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Improving Physical Backup/Restore within the Low Level API
Next
From: Erik Wienhold
Date:
Subject: Re: Fix output of zero privileges in psql