Re: 8.2 Autovacuum BUG ? - Mailing list pgsql-performance

Hi Álvaro Herrera,

Please find the corresponding output:

*1).select name, setting, source, sourcefile, sourceline from pg_settings
where name like '%vacuum%'; *
-[ RECORD 1 ]----------------------------------------
name       | autovacuum
setting    | on
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 437
-[ RECORD 2 ]----------------------------------------
name       | autovacuum_analyze_scale_factor
setting    | 0.1
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 451
-[ RECORD 3 ]----------------------------------------
name       | autovacuum_analyze_threshold
setting    | 50
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 448
-[ RECORD 4 ]----------------------------------------
name       | autovacuum_freeze_max_age
setting    | 200000000
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 452
-[ RECORD 5 ]----------------------------------------
name       | autovacuum_max_workers
setting    | 3
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 443
-[ RECORD 6 ]----------------------------------------
name       | autovacuum_naptime
setting    | 60
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 445
-[ RECORD 7 ]----------------------------------------
name       | autovacuum_vacuum_cost_delay
setting    | 20
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 454
-[ RECORD 8 ]----------------------------------------
name       | autovacuum_vacuum_cost_limit
setting    | -1
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 457
-[ RECORD 9 ]----------------------------------------
name       | autovacuum_vacuum_scale_factor
setting    | 0.2
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 450
-[ RECORD 10 ]---------------------------------------
name       | autovacuum_vacuum_threshold
setting    | 50
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 446
-[ RECORD 11 ]---------------------------------------
name       | log_autovacuum_min_duration
setting    | 100
source     | configuration file
sourcefile | /etc/postgresql/9.1/main/postgresql.conf
sourceline | 439
-[ RECORD 12 ]---------------------------------------
name       | vacuum_cost_delay
setting    | 0
source     | default
sourcefile |
sourceline |
-[ RECORD 13 ]---------------------------------------
name       | vacuum_cost_limit
setting    | 200
source     | default
sourcefile |
sourceline |
-[ RECORD 14 ]---------------------------------------
name       | vacuum_cost_page_dirty
setting    | 20
source     | default
sourcefile |
sourceline |
-[ RECORD 15 ]---------------------------------------
name       | vacuum_cost_page_hit
setting    | 1
source     | default
sourcefile |
sourceline |
-[ RECORD 16 ]---------------------------------------
name       | vacuum_cost_page_miss
setting    | 10
source     | default
sourcefile |
sourceline |
-[ RECORD 17 ]---------------------------------------
name       | vacuum_defer_cleanup_age
setting    | 0
source     | default
sourcefile |
sourceline |
-[ RECORD 18 ]---------------------------------------
name       | vacuum_freeze_min_age
setting    | 50000000
source     | default
sourcefile |
sourceline |
-[ RECORD 19 ]---------------------------------------
name       | vacuum_freeze_table_age
setting    | 150000000
source     | default
sourcefile |
sourceline |


*2).select oid::regclass, reloptions from pg_class where reloptions is not
null; *

(No rows)



Thanks in Advance.


Regards,
Pavan




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html