Re: generating a large XML document

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2011/6/20 Pavel Stehule <pavel.stehule@xxxxxxxxx>:
> 2011/6/20 Julius Tuskenis <julius@xxxxxxxx>:
>> 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@xxxxxxxxxxxxxx)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>>
>

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux