[hackers-jp: 194] [Fwd: Re: [HACKERS] Open items]

[Hiroki Kataoka]

片岡です。

　下記の永安さんとTomとのやり取りですが、たぶん、GUCのパラメータが
sort_memではなくてwork_memになったということもあり、sortの場合だけを
チェックするんではなくて、テンポラリファイルを使う場合の全てをチェックで
きないか？という話かもしれません。想像ですが。

-------- Original Message --------
Subject: Re: [HACKERS] Open items
Date: Thu, 30 Jun 2005 15:47:52 +0900
From: Satoshi Nagayasu <nagayasus ＠ nttdata.co.jp>
To: Tom Lane <tgl ＠ sss.pgh.pa.us>
CC: josh ＠ agliodbs.com, Bruce Momjian <pgman ＠ candle.pha.pa.us>,
PostgreSQL-development <pgsql-hackers ＠ postgresql.org>
References: <200506291149.j5TBnvl29848 ＠ candle.pha.pa.us>
<42C32B56.4000508 ＠ nttdata.co.jp> <200506291923.35155.josh ＠ agliodbs.com>
<13876.1120101148 ＠ sss.pgh.pa.us> <42C36726.2060100 ＠ nttdata.co.jp>
<14225.1120103374 ＠ sss.pgh.pa.us>

Tom Lane wrote:
>>My patch counts inittapes(), tuplesort_begin_heap() and
>>tuplesort_begin_index(), and collect them, and sum them through the
>>stat collector.
> 
> 
> Hm, that doesn't seem like quite the right level to be counting at.
> Shouldn't you be hacking fd.c to count operations on FD_XACT_TEMPORARY
> files?

Why do you think so?
I don't see tuplesort.c is good or not.

But all code of sort operations are in tuplesort.c.
So I thought it is a good place to count them up.

Of course, I can move my code to fd.c if it will be reasonable.

-- 
NAGAYASU Satoshi <nagayasus ＠ nttdata.co.jp>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

-- 
Hiroki Kataoka <kataoka ＠ interwiz.jp>