| From: | Ali Akbar <the(dot)apaan(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [REVIEW] Re: Fix xpath() to return namespace definitions |
| Date: | 2014-12-14 15:18:44 |
| Message-ID: | CACQjQLri-53oE_2FMWLmsAyi1Zuzb4uGbzHQPyVNjEXQ2n8q2A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> I ran a test using postgres-US.fo built in the PostgreSQL source tree,
> which is 38 MB, and ran
>
> select unnest(xpath('//fo:bookmark-title', b, array[array['fo',
> 'http://www.w3.org/1999/XSL/Format']])) from data;
>
> (Table contains one row only.)
>
> The timings were basically indistinguishable between the three code
> versions.
>
> I'll try to reproduce your test. How big is your file? Do you have a
> link to the actual file? Could you share your load script?
>
I use this xml sample:
http://w3.energistics.org/schema/prodml_v1.2.0_data/XML_Examples/productVolume_no_xsl.xml
Basically i loaded the xml to table u 100 times. Load script attached.
Regards,
--
Ali Akbar
| Attachment | Content-Type | Size |
|---|---|---|
| load_test.sql | application/sql | 49.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2014-12-14 15:21:33 | Re: pg_basebackup vs. Windows and tablespaces |
| Previous Message | Greg Sabino Mullane | 2014-12-14 15:12:12 | Re: Commitfest problems |