if
they are executing the same query over the same set of data?
Fava.
Il 11/02/2011 22:49, Nicolas Barbier ha scritto:
2011/2/11 Kevin Grittner:
"mac_man2...@yahoo.it" wrote:
I need to know, from an algorithmic point of view, in which cases
sorting is invoked.
[..]
Are y
.)
- ...
Is it possible?
Any other suggestion?
Thanks for your time.
Best regards.
Fava
Il 11/02/2011 11:50, Nicolas Barbier ha scritto:
[ Please don't top-post.http://en.wikipedia.org/wiki/Posting_style> ]
2011/2/11 mac_man2...@yahoo.it:
So, is there any precise way to discover
Thank you all for your replies.
So, is there any precise way to discover when sorting is invoked?
Thanks.
Regards.
Fava
Il 11/02/2011 01:17, Robert Haas ha scritto:
On Thu, Feb 10, 2011 at 6:21 PM, Nicolas Barbier
wrote:
2011/2/10 mac_man2...@yahoo.it:
Which operations invoke the
Hi.
Which operations invoke the sorting algorithms implemented in the
sorting module (tuplesort.c) ?
Of course, one of those operations invoking sorting is the ORDER BY
clause and the DISTINCT too.
Moreover, the Merge Join should be implemented invoking sorting.
Is there any other operation
Hi to all.
I am trying to see how PostgreSQL performance changes on the basis of
work_mem. So, I am going to execute the 22 queries of TPCH
(http://www.tpc.org/tpch/) again and again, each time for a different
value of work_mem.
Since I am interested just in work_mem variations, I should preve
