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: (view raw, whole thread or download thread mbox)
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.


> 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:

In response to


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-2018 The PostgreSQL Global Development Group