Re: SQL Property Graph Queries (SQL/PGQ)

From: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: assam258(at)gmail(dot)com, Amit Langote <amitlangote09(at)gmail(dot)com>, Junwang Zhao <zhjwpku(at)gmail(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, Ajay Pal <ajay(dot)pal(dot)k(at)gmail(dot)com>, Imran Zaheer <imran(dot)zhir(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
Date: 2026-01-13 16:09:44
Message-ID: CAExHW5tOH2HPaypJ1Ys6BSh_f4+tE2Oy=qGfXEQPGsogGeki+Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 13, 2026 at 3:47 PM Peter Eisentraut <peter(at)eisentraut(dot)org> wrote:
>
> On 02.01.26 09:48, Ashutosh Bapat wrote:
> >> #1 [Code] src/backend/commands/propgraphcmds.c:1632
> >> FIXME: Missing index for plppropid column causes sequential scan.
> >> Decision needed: (a) add index, or (c) allow seq scan for rare path.
> >
> > The path is rare enough that I think we can allow the seq scan. Given
> > that Peter has marked it as FIXME, it seems we will keep it as is for
> > now, but will revisit if performance becomes an issue. Peter, please
> > correct me if I'm wrong.
>
> Yeah, doesn't seem critical. Maybe "downgrade" to "XXX".

I see you have done in the patch attached to your next response.

>
> >> #5 [Doc] doc/src/sgml/queries.sgml:2929,2931
> >> TODO comments for unimplemented features without clear limitation notes.
> >
> > Those TODOs are not visible to users. I think they serve as
> > placeholders to add the documentation when the features are
> > implemented. We may want to remove them, but I see no harm in keeping
> > them for now. Peter, what do you think?
>
> We should keep them and fill them in. :)
>

Works for me.

--
Best Wishes,
Ashutosh Bapat

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2026-01-13 16:14:22 Re: SQL Property Graph Queries (SQL/PGQ)
Previous Message Ashutosh Bapat 2026-01-13 16:08:43 Re: SQL Property Graph Queries (SQL/PGQ)