Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum and autovacuum - is it good to configure the thresholdat TABLE LEVEL? - Mailing list pgsql-hackers

From rajan
Subject Re: vacuum and autovacuum - is it good to configure the thresholdat TABLE LEVEL?
Date
Msg-id 1543376490729-0.post@n3.nabble.com
Whole thread Raw
In response to Re: vacuum and autovacuum - is it good to configure the threshold atTABLE LEVEL?  (amul sul <sulamul@gmail.com>)
Responses Re: vacuum and autovacuum - is it good to configure the threshold atTABLE LEVEL?  (amul sul <sulamul@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: "pg_ctl: the PID file ... is empty" at end of make check
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SETSTATISTICS