From: | Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Open items |
Date: | 2005-06-29 23:14:30 |
Message-ID: | 42C32B56.4000508@nttdata.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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 <nagayasus(at)nttdata(dot)co(dot)jp>
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2005-06-30 01:34:41 | Re: Checkpoint cost, looks like it is WAL/CRC |
Previous Message | Tom Lane | 2005-06-29 23:00:04 | Re: [HACKERS] Dbsize backend integration |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-06-29 23:34:56 | Autovacuum integration patch |
Previous Message | Tom Lane | 2005-06-29 23:00:04 | Re: [HACKERS] Dbsize backend integration |