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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Julius Tuskenis | 2011-06-20 09:03:21 | Re: generating a large XML document |
Previous Message | Didik Prasetyo | 2011-06-20 07:57:12 | how to know slowly query in lock postgre |