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", tick_b
2011/6/20 Pavel Stehule :
> 2011/6/20 Julius Tuskenis :
>> 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 sp
2011/6/20 Julius Tuskenis :
> 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
> programme
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 (pgsql-pe
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
On Sun, Jun 19, 2011 at 11:36 PM, Julius Tuskenis 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 no answer
>
Hello
2011/6/20 Julius Tuskenis :
> 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 g
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 s
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 tha
