From 936f3d40162670d9b721563a94b21ee87ab8d866 Mon Sep 17 00:00:00 2001 From: =?utf8?q?C=C3=A9dric=20Villemain?= Date: Sat, 8 Aug 2009 02:22:59 +0200 Subject: [PATCH] add some text to README --- ChangeLog | 5 +++++ README.pgfincore | 16 +++++++++++----- 2 files changed, 16 insertions(+), 5 deletions(-) diff --git a/ChangeLog b/ChangeLog index eef3606..6fa1fa8 100644 --- a/ChangeLog +++ b/ChangeLog @@ -5,3 +5,8 @@ 06/29/2009 Cédric Villemain * 0.1.1 - cleaning and fixing + +08/08/2009 Cédric Villemain + + * 0.2 - add support for 8.4 + - fix mmap error when file is empty diff --git a/README.pgfincore b/README.pgfincore index 2dc9fbc..4bd89ec 100644 --- a/README.pgfincore +++ b/README.pgfincore @@ -1,17 +1,23 @@ -v0.1 +Version : +v0.2 -make clean && make && sudo make install +Install: +./configure && make clean && make && sudo make install Create the functions from the sql script (it should be in your contrib directory) +Debug: +set client_min_messages TO debug; + +Use it: select relname, pg_size_pretty(size) as size, size/4/1024 as block_disk, block_mem, - (block_mem*4*1024*100/size)||' %' as block_ratio + CASE WHEN size=0 then '0 %' ELSE (block_mem*4*1024*100/size)||' %' END as block_ratio from (select relname, - pgfincore(relname) as block_mem, - pg_relation_size(relname) as size + pgfincore(relname::text) as block_mem, + pg_relation_size(relname::text) as size from pg_stat_user_tables ) s order by 3 desc; -- 2.39.5