| 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: | Whole Thread | Raw Message | 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 |