2011/6/20 Pavel Stehule <pavel.steh...@gmail.com>: > 2011/6/20 Julius Tuskenis <jul...@nsoft.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-performance >> > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance