Re: Postgres Architecture - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Postgres Architecture
Date
Msg-id CADUqk8VrzFkeAsiZEBnadV2QMXMCJwHgZnMO0LOwdUv79i0xUA@mail.gmail.com
Whole thread Raw
In response to Postgres Architecture  (Timothy Nelson <wayland@wayland.id.au>)
Responses Re: Postgres Architecture
List pgsql-hackers
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: Robert Haas
Date:
Subject: Re: Server crash on RHEL 9/s390x platform against PG16
Next
From: David Steele
Date:
Subject: Re: Rename backup_label to recovery_control