Skip site navigation (1) Skip section navigation (2)

Re: generating a large XML document

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Julius Tuskenis <julius(at)nsoft(dot)lt>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: generating a large XML document
Date: 2011-06-20 07:58:15
Message-ID: BANLkTim2+pQQz7wCaSbt5M3YrfGQtSVK0A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2011/6/20 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 2011/6/20 Julius Tuskenis <julius(at)nsoft(dot)lt>:
>> Thank you, Pavel for your answer
>>
>> 2011.06.20 09:51, Pavel Stehule rašė:
>>>
>>> can you send a profile?
>>
>> Excuse me, but what do you mean by saying "profile"? I've sent content of
>> pg_settings in the first post. Please be more specific as I am more of a
>> programmer than an server administrator.
>>
>
> a result from oprofile profiler
>

I looked into code - probably a implementation of xmlagg is too silly

xmlagg use a xmlconcat functions - that means repeated xml parsing and
xmlserialization. So it is not effective on larger trees :(

string_agg is more effective now. The solution is only radical
refactoring of xmlagg function.

Pavel




> Regards
>
> Pavel
>
>> --
>> Julius Tuskenis
>> Programavimo skyriaus vadovas
>> UAB nSoft
>> mob. +37068233050
>>
>>
>> --
>> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>>
>

In response to

Responses

pgsql-performance by date

Next:From: Julius TuskenisDate: 2011-06-20 09:03:21
Subject: Re: generating a large XML document
Previous:From: Didik PrasetyoDate: 2011-06-20 07:57:12
Subject: how to know slowly query in lock postgre

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group