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 | 11141120 template1 | 2 | 0 | 0 | 0 | 792 template0 | 0 | 0 | 0 | 0 | 0 (3 rows) Is this enough for this TODO? Any comments? -- NAGAYASU Satoshi <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
