Bruce,
I have another patch for the TODO item.
From TODO item:
> Add ability to monitor the use of temporary sort files
As I mentioned before, I created a sort statistics patch.
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00380.php
Now my patch can work with 7.4.6 and it creates new system view,
called pg_stat_sorts.
sort=# select * from pg_stat_sorts ; datname | heap_all | index_all | heap_tape | index_tape | max_size
-----------+----------+-----------+-----------+------------+----------sort | 11 | 0 | 3 |
0 | 11141120template1 | 2 | 0 | 0 | 0 | 792template0 | 0 | 0 |
0 | 0 | 0
(3 rows)
Is this enough for this TODO?
Any comments?
--
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>
