pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Auto Vacuum Daemon not running even though it's been configured 2+ messages / 2 participants [nested] [flat]
* Auto Vacuum Daemon not running even though it's been configured @ 2015-07-22 02:16 Wei Shan <weishan.ang@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Wei Shan @ 2015-07-22 02:16 UTC (permalink / raw) To: pgsql-admin Hi all, I'm running PostgreSQL 9.2.4. I have autovacuum configured within my database. However, when I verify it, it has never been ran even though the autovacuum process is running. *Autovacuum Parameters:* postgres=# show autovacuum; autovacuum ------------ on postgres=# show track_counts; track_counts -------------- on *Verification:* *Step 1:* [root@tiffany1 ~]# grep autovacuum /var/log/messages *Step 2:* [root@tiffany1 ~]# ps -aef | grep autovacuum postgres 4923 4883 0 Jul20 ? 00:00:15 postgres: autovacuum launcher process root 52995 5313 0 10:12 pts/0 00:00:00 grep autovacuum *Step 3:* select schemaname,relname,last_vacuum,last_autovacuum,last_analyze,last_autoanalyze,vacuum_count,autovacuum_count,analyze_count,autoanalyze_count from pg_stat_user_tables; All the values were 0 for the tables in every single database. Any advice please? Thanks! -- Regards, Ang Wei Shan ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Auto Vacuum Daemon not running even though it's been configured @ 2015-07-22 02:46 Joshua D. Drake <jd@commandprompt.com> parent: Wei Shan <weishan.ang@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2015-07-22 02:46 UTC (permalink / raw) To: Wei Shan <weishan.ang@gmail.com>; pgsql-admin On 07/21/2015 07:16 PM, Wei Shan wrote: > > > > Any advice please? 1. Get the heck off 9.2.4 (9.2.13 is the recommended version) 2. Try analyzing the database and then doing a large update on a test table 3. report back results. > > Thanks! > > > -- > Regards, > Ang Wei Shan -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-07-22 02:46 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-07-22 02:16 Auto Vacuum Daemon not running even though it's been configured Wei Shan <weishan.ang@gmail.com> 2015-07-22 02:46 ` Joshua D. Drake <jd@commandprompt.com>
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