Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?

From: rajan <vgmonnet(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: vacuum and autovacuum - is it good to configure the threshold at TABLE LEVEL?
Date: 2018-11-28 03:41:30
Message-ID: 1543376490729-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thanks, amul. I have already gone through this. What I would like to
understand is the performance impact on autovacuum launcher and worker
process when autovacuum is running from configurations done by
*ALTER TABLE autvac_test SET (autovacuum_vacuum_scale_factor = 0,
autovacuum_vacuum_threshold = 100);*
at table level.

-----
--
Thanks,
Rajan.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2018-11-28 04:03:15 Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0
Previous Message Thomas Munro 2018-11-28 03:18:35 Re: "pg_ctl: the PID file ... is empty" at end of make check