Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing an XMLTABLE query? - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: Indexing an XMLTABLE query?
Date
Msg-id CAFj8pRBX6uxDuk5hjKzwpLT9S9dS5P5p-Y_APjsXLB382bgPzA@mail.gmail.com
Whole thread Raw
In response to Indexing an XMLTABLE query?  (Kanninen Anssi EXT <Anssi.Kanninen@digia.com>)
List pgsql-performance
Tree view
Hi

pá 9. 10. 2020 v 7:40 odesílatel Kanninen Anssi EXT <Anssi.Kanninen@digia.com> napsal:

Hi there!

 

Is there any way to use indexes with XMLTABLE-query to query XML type data?

I've only managed to use text[] indexes with plain xpath queries. Is there any similar workaround for XMLTABLE type queries?


XMLTABLE returning set of records, and for these functions there are not functional indexes

Regards

Pavel


 

Cheers!

  • Anssi Kanninen, Helsinki, Finland

pgsql-performance by date:

Previous
From: Kanninen Anssi EXT
Date:
Subject: Indexing an XMLTABLE query?
Next
From: "Gopisetty, Ramesh"
Date:
Subject: Re: Performance issue when we use policies for Row Level Security along with functions