Re: Proposal to use JSON for Postgres Parser format - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal to use JSON for Postgres Parser format
Date
Msg-id 568917.1663645189@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal to use JSON for Postgres Parser format  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Proposal to use JSON for Postgres Parser format
List pgsql-hackers
Peter Geoghegan <pg@bowt.ie> writes:
> Writing declarative @> containment queries against (say) a JSON
> variant of node tree format seems like it could be a huge quality of
> life improvement.

There are certainly use-cases for something like that, but let's
be clear about it: that's a niche case of interest to developers
and pretty much nobody else.  For ordinary users, what matters about
the node tree storage format is compactness and speed of loading.
Our existing format is certainly not great on those metrics, but
I do not see how "let's use JSON!" is a route to improvement.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Proposal to use JSON for Postgres Parser format
Next
From: "shiy.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply