Re: SQL Property Graph Queries (SQL/PGQ) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: SQL Property Graph Queries (SQL/PGQ)
Date
Msg-id 20240216192301.q2tf4bqjydymg3g2@awork3.anarazel.de
Whole thread Raw
In response to SQL Property Graph Queries (SQL/PGQ)  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: SQL Property Graph Queries (SQL/PGQ)
List pgsql-hackers
Hi,

On 2024-02-16 15:53:11 +0100, Peter Eisentraut wrote:
> The patch is quite fragile, and treading outside the tested paths will
> likely lead to grave misbehavior.  Use with caution.  But I feel that
> the general structure is ok, and we just need to fill in the
> proverbial few thousand lines of code in the designated areas.

One aspect that I m concerned with structurally is that the transformation,
from property graph queries to something postgres understands, is done via the
rewrite system. I doubt that that is a good idea. For one it bars the planner
from making plans that benefit from the graph query formulation. But more
importantly, we IMO should reduce usage of the rewrite system, not increase
it.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: System username in pg_stat_activity
Next
From: Magnus Hagander
Date:
Subject: Re: System username in pg_stat_activity