Indexing an XMLTABLE query?

From: Kanninen Anssi EXT <Anssi(dot)Kanninen(at)digia(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Indexing an XMLTABLE query?
Date: 2020-10-09 05:39:49
Message-ID: DB6PR02MB32548E4C07F319A2A0039FBE99080@DB6PR02MB3254.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Cheers!

* Anssi Kanninen, Helsinki, Finland

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2020-10-09 05:59:04 Re: Indexing an XMLTABLE query?
Previous Message avinash varma 2020-10-06 03:59:08 Re: Too many waits on extension of relation