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
