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

help / color / mirror / Atom feed
From: Om Prakash Jaiswal <op12om@yahoo.co.in>
To: John Scalia <jayknowsunix@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Autovacuum behavior
Date: Fri, 31 Jul 2015 04:44:27 +0000 (UTC)
Message-ID: <810264764.37549.1438317867083.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CABzCKRDtMfmgKFoMeTFDRGif+siQK9bXM4791ii8ZBJfORSFNA@mail.gmail.com>
References: <CABzCKRDtMfmgKFoMeTFDRGif+siQK9bXM4791ii8ZBJfORSFNA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

track_count = on;It is missing.

RegardsOm Prakash 


     On Friday, 31 July 2015 12:21 AM, John Scalia <jayknowsunix@gmail.com> wrote:
   

 Hi all,
The autovacuum settings for a 9.4.2 database are shown below, I'm not absolutely certain if I missed anything:
autovacuum = onlog_autovacuum_min_duration = 100autovacuum_max_workers = 15autovacuum_naptime = 10min#autovacuum_vacuum_threshold = 50autovacuum_analyze_threshold = 80autovacuum_vacuum_scale_factor = 0.1autovacuum_analyze_scale_factor = 0.2autovacuum_freeze_max_age = 100000000autovacuum_vacuum_cost_delay = 20msautovacuum_vacuum_cost_limit = -1vacuum_freeze_min_age =   5000000vacuum_freeze_table_age = 2500000

But, when I examine pg_stat_all_tables, I'm seeing a lot of tables where n_dead_tup is still a lot greater than n_live_tup. Mind you, these are all fairly small tables. I'm also seeing that the last_autovacuum ran about 11:22 AM CDT this morning.I would think the tables where there were no live tuples and a bunch of dead_tuples would have been vacuumed after 11:22 AM to clear the dead ones. Am I missing something?--Jay

  

view thread (8+ messages)  latest in thread

Message-ID: <810264764.37549.1438317867083.JavaMail.yahoo@mail.yahoo.com>
Permalink:  ../810264764.37549.1438317867083.JavaMail.yahoo@mail.yahoo.com/
Also on:    postgresql.org/message-id/810264764.37549.1438317867083.JavaMail.yahoo@mail.yahoo.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-admin@postgresql.org
  Cc: op12om@yahoo.co.in, jayknowsunix@gmail.com
  Subject: Re: Autovacuum behavior
  In-Reply-To: <810264764.37549.1438317867083.JavaMail.yahoo@mail.yahoo.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