pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: 8.2 Autovacuum BUG ?
Date: Wed, 24 Jan 2018 20:47:15 -0700 (MST)
Message-ID: <1516852035576-0.post@n3.nabble.com> (raw)
In-Reply-To: <20180124151920.vonyeexv7qqledjy@alvherre.pgsql>
References: <CACh9nsb5dF6wNC=iyaxGyrHZ212QkbtXtO36it9u-QhOFr6j2g@mail.gmail.com>
	<CAGTBQpYhg_Ow3SBmUd4=ycepDp5eJin-ou1kBAasQ5EyuE-n+A@mail.gmail.com>
	<CACh9nsYX23u1eLngVx2j5_0CBhUH=MJN9HE6iYOSgNrk5gfnFw@mail.gmail.com>
	<CAGTBQpYkYXemTpuNwVMhV-EiwUBiBhiqO2rtAgFXxWy0kF15QA@mail.gmail.com>
	<1516776879945-0.post@n3.nabble.com>
	<CAGTBQpa-mTQ9qA18xVimrgTmrXZnFAnqKpzHYwCNtc=GEEd+5w@mail.gmail.com>
	<1516794633075-0.post@n3.nabble.com>
	<CAGTBQpbDRmAaiveO2bDOtXhdBJBqcgvfzmp69=XKDJ3mKcQCHg@mail.gmail.com>
	<CACh9nsYDjR817FpH+gs_81WtcOSRyc_0SU_VZM9haOm_b4wOGg@mail.gmail.com>
	<20180124151920.vonyeexv7qqledjy@alvherre.pgsql>

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




view thread (46+ messages)  latest in thread

Message-ID: <1516852035576-0.post@n3.nabble.com>
Permalink:  ../1516852035576-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1516852035576-0.post@n3.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pavan.postgresdba@gmail.com
  Subject: Re: 8.2 Autovacuum BUG ?
  In-Reply-To: <1516852035576-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox