Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eeYVW-0005qd-V0 for pgsql-performance@arkaria.postgresql.org; Thu, 25 Jan 2018 03:47:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eeYVV-0003PO-Qt for pgsql-performance@arkaria.postgresql.org; Thu, 25 Jan 2018 03:47:21 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eeYVV-0003PE-GR for pgsql-performance@lists.postgresql.org; Thu, 25 Jan 2018 03:47:21 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eeYVR-0006PY-BU for pgsql-performance@postgresql.org; Thu, 25 Jan 2018 03:47:19 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 970CAAD09F39 for ; Wed, 24 Jan 2018 20:47:15 -0700 (MST) Date: Wed, 24 Jan 2018 20:47:15 -0700 (MST) From: pavan95 To: pgsql-performance@postgresql.org Message-ID: <1516852035576-0.post@n3.nabble.com> In-Reply-To: <20180124151920.vonyeexv7qqledjy@alvherre.pgsql> References: <1516776879945-0.post@n3.nabble.com> <1516794633075-0.post@n3.nabble.com> <20180124151920.vonyeexv7qqledjy@alvherre.pgsql> Subject: Re: 8.2 Autovacuum BUG ? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi =C3=81lvaro 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-f205008= 1.html