Re: [HACKERS] External Sort timing debug statements

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] External Sort timing debug statements
Date: 2005-10-03 15:07:28
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC30F8@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> -----Original Message-----
> From: pgsql-patches-owner(at)postgresql(dot)org
> [mailto:pgsql-patches-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 03 October 2005 15:37
> To: Simon Riggs
> Cc: pgsql-hackers(at)postgresql(dot)org; pgsql-patches(at)postgresql(dot)org
> Subject: Re: [PATCHES] [HACKERS] External Sort timing debug
> statements
>
> 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.

Agreed.

> > postgres=# set debug_sort=true;
>
> I'm a bit inclined to call it trace_sort instead, and to document it
> under "Developer Options". Comments?

Sounds reasonable to me.

Regards, Dave.

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2005-10-03 15:19:43 Re: Build Farm: thrush
Previous Message Jonah H. Harris 2005-10-03 14:46:40 Re: External Sort timing debug statements

Browse pgsql-patches by date

  From Date Subject
Next Message Qingqing Zhou 2005-10-03 16:28:26 Re: cleanup log_disconnections()
Previous Message Jonah H. Harris 2005-10-03 14:46:40 Re: External Sort timing debug statements