Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: Josh BerkusDate: 2005-06-30 01:34:41
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Previous:From: Tom LaneDate: 2005-06-29 23:00:04
Subject: Re: [HACKERS] Dbsize backend integration

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2005-06-29 23:34:56
Subject: Autovacuum integration patch
Previous:From: Tom LaneDate: 2005-06-29 23:00:04
Subject: Re: [HACKERS] Dbsize backend integration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group