Re: External Sort timing debug statements

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: External Sort timing debug statements
Date: 2005-10-03 14:46:40
Message-ID: 36e682920510030746y13d061f2ycca2b131e94e1db2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

I'm not averse to it. I think it's a good option and I support trace_sort
(it really is more of a trace).

On 10/3/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Simon Riggs <simon(at)2ndquadrant(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Respectfully,

Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
http://www.enterprisedb.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2005-10-03 15:07:28 Re: [HACKERS] External Sort timing debug statements
Previous Message Tom Lane 2005-10-03 14:36:57 Re: [HACKERS] External Sort timing debug statements

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Page 2005-10-03 15:07:28 Re: [HACKERS] External Sort timing debug statements
Previous Message Tom Lane 2005-10-03 14:36:57 Re: [HACKERS] External Sort timing debug statements