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
