Changeset 34 for trunk/phpgwapi/inc/adodb/perf/perf-postgres.inc.php

Timestamp:

06/29/07 15:17:46 (17 years ago)

Author:

niltonneto

Message:

Versão nova do ADODB (4.5 para 4.95)

File:

• trunk/phpgwapi/inc/adodb/perf/perf-postgres.inc.php (modified) (4 diffs)

trunk/phpgwapi/inc/adodb/perf/perf-postgres.inc.php

@@ -2 +2 @@
 
 /* 
-V4.51 29 July 2004  (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
+V4.94 23 Jan 2007  (c) 2000-2007 John Lim (jlim#natsoft.com.my). All rights reserved.
   Released under both BSD license and Lesser GPL library license. 
   Whenever there is any discrepancy between the two licenses, 
@@ -43 +43 @@
                         'Value must be TRUE to enable hit ratio statistics (<i>stats_start_collector</i>,<i>stats_row_level</i> and <i>stats_block_level</i> must be set to true in postgresql.conf)'),
                 'data cache hit ratio' => array('RATIO',
-                        "select case when blks_hit=0 then 0 else (1-blks_read::float/blks_hit)*100 end from pg_stat_database where datname='\$DATABASE'",
+                        "select case when blks_hit=0 then 0 else round( ((1-blks_read::float/blks_hit)*100)::numeric, 2) end from pg_stat_database where datname='\$DATABASE'",
                         '=WarnCacheRatio'),
         'IO',
@@ -50 +50 @@
                 ),
                 'data writes' => array('IO',
-                'select sum(n_tup_ins/4.0+n_tup_upd/8.0+n_tup_del/4.0)/16 from pg_stat_user_tables',
+                'select round((sum(n_tup_ins/4.0+n_tup_upd/8.0+n_tup_del/4.0)/16)::numeric,2) from pg_stat_user_tables',
                 'Count of inserts/updates/deletes * coef'),
 
@@ -67 +67 @@
                         '(effective cache size)' ),
         'Memory Usage',
-                'sort buffer size' => array('CACHE',
-                        "select setting::integer*1024 from pg_settings where name='sort_mem'",
+        # Postgres 7.5 changelog: Rename server parameters SortMem and VacuumMem to work_mem and maintenance_work_mem;
+                'sort/work buffer size' => array('CACHE',
+                        "select setting::integer*1024 from pg_settings where name='sort_mem' or name = 'work_mem' order by name",
                         'Size of sort buffer (per query)' ),
         'Connections',