Re: Open items

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>

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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