| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Kanninen Anssi EXT <Anssi(dot)Kanninen(at)digia(dot)com> |
| Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Indexing an XMLTABLE query? |
| Date: | 2020-10-09 05:59:04 |
| Message-ID: | CAFj8pRBX6uxDuk5hjKzwpLT9S9dS5P5p-Y_APjsXLB382bgPzA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi
pá 9. 10. 2020 v 7:40 odesílatel Kanninen Anssi EXT <
Anssi(dot)Kanninen(at)digia(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gopisetty, Ramesh | 2020-10-12 06:46:56 | Re: Performance issue when we use policies for Row Level Security along with functions |
| Previous Message | Kanninen Anssi EXT | 2020-10-09 05:39:49 | Indexing an XMLTABLE query? |