Re: 8.2 Autovacuum BUG ?

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