[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: Indexing an XMLTABLE query?
From:       Pavel Stehule <pavel.stehule () gmail ! com>
Date:       2020-10-09 5:59:04
Message-ID: CAFj8pRBX6uxDuk5hjKzwpLT9S9dS5P5p-Y_APjsXLB382bgPzA () mail ! gmail ! com
[Download RAW message or body]

Hi

p=C3=A1 9. 10. 2020 v 7:40 odes=C3=ADlatel Kanninen Anssi EXT <
Anssi.Kanninen@digia.com> napsal:

> Hi there!
>
>
>
> Is there any way to use indexes with XMLTABLE-query to query XML type dat=
a?
>
> I've only managed to use text[] indexes with plain xpath queries. Is ther=
e
> 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
>
>

[Attachment #3 (text/html)]

<div dir="ltr"><div>Hi<br></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">pá 9. 10. 2020 v  7:40 odesílatel Kanninen Anssi EXT &lt;<a \
href="mailto:Anssi.Kanninen@digia.com">Anssi.Kanninen@digia.com</a>&gt; \
napsal:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">





<div lang="FI">
<div class="gmail-m_5476022197822692614WordSection1">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Hi there!<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u>  <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Is there any way to use indexes with \
XMLTABLE-query to query XML type data?<u></u><u></u></span></p> <p \
class="MsoNormal"><span lang="EN-US">I&#39;ve only managed to use text[] indexes with \
plain xpath queries. Is there any similar workaround for XMLTABLE type \
queries?</span></p></div></div></div></div></blockquote><div><br></div><div>XMLTABLE \
returning set of records, and for these functions there are not functional \
indexes</div><div><br></div><div>Regards</div><div><br></div><div>Pavel<br></div><div><br></div><div><br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div lang="FI"><div \
class="gmail-m_5476022197822692614WordSection1"><div><div><p class="MsoNormal"><span \
lang="EN-US"><u></u><u></u></span></p> <p class="MsoNormal"><span \
lang="EN-US"><u></u>  <u></u></span></p> <p class="MsoNormal"><span \
lang="EN-US">Cheers!<u></u><u></u></span></p> <ul style="margin-top:0cm" type="disc">
<li class="gmail-m_5476022197822692614MsoListParagraph" style="margin-left:0cm"><span \
lang="EN-US">Anssi Kanninen, Helsinki, Finland<u></u><u></u></span></li></ul> </div>
</div>
</div>
</div>

</blockquote></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]