Hello,
I'm sorry to write again, but as I received no answer I wonder if there
is a better mailing list to address concerning this question? Or is
there nothing to be done about the speed of xmlagg ?. Please let me as
no answer is the worst answer to get
--
Julius Tuskenis
Programavimo
Hello
2011/6/20 Julius Tuskenis jul...@nsoft.lt:
Hello,
I'm sorry to write again, but as I received no answer I wonder if there is a
better mailing list to address concerning this question? Or is there nothing
to be done about the speed of xmlagg ?. Please let me as no answer is the
worst
On Sun, Jun 19, 2011 at 11:36 PM, Julius Tuskenis jul...@nsoft.lt wrote:
Hello,
I'm sorry to write again, but as I received no answer I wonder if there is
a better mailing list to address concerning this question? Or is there
nothing to be done about the speed of xmlagg ?. Please let me as
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.
--
Julius
Thank You, Samuel for the time it took to investigate the issue.
I'll try to use buffer to see what the results are... I'll post results
to the list if I succeed.
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--
Sent via pgsql-performance mailing list
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
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.
2011.06.20 10:58, Pavel Stehule rašė:
string_agg is more effective now. The solution is only radical
refactoring of xmlagg function.
Thank you, Pavel for letting me know of string_agg.
explain analyze
SELECT
string_agg(
XMLELEMENT ( NAME bar,
XMLELEMENT ( NAME code,
Hello, postgresql guru's
When developing ticket export mechanism for our ticketing system I
thought the wise thing would be to generate the result (XML file) in
stored function. This worked fine for small datasets, but for the larger
ones I see it takes much longer to generate the document