Re: External Sort timing debug statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: External Sort timing debug statements
Date
Msg-id 22098.1128350217@sss.pgh.pa.us
Whole thread Raw
In response to External Sort timing debug statements  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: External Sort timing debug statements  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: [PATCHES] External Sort timing debug statements  (David Fetter <david@fetter.org>)
Re: External Sort timing debug statements  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> The following patch implements a fairly light set of timing statements
> aimed at understanding external sort performance. There is no attempt to
> alter the algorithms.

What do people think about putting something like this into 8.1?
Strictly speaking it's a new feature, but the patch seems pretty
noninvasive, and we'd be much more likely to get data points if the
code exists in the mainline release than if people have to patch
their copies.

> postgres=# set debug_sort=true;

I'm a bit inclined to call it trace_sort instead, and to document it
under "Developer Options".  Comments?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG Killed by OOM Condition
Next
From: "Jonah H. Harris"
Date:
Subject: Re: External Sort timing debug statements