About Autovacuum Query

From: jaya kumar <kumardba27(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: About Autovacuum Query
Date: 2024-04-03 09:55:23
Message-ID: CACd4L3v-dD8yOWpKZRB+R=pgQY0sDAH5eRMqiS6vKiDNifm3ng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team,

In my database Autovacuum is enabled and sets the below updated value in
the Autovacuum related parameter. Here my question is after performing
Autovacuum on a daily basis the below value is coming in n_dead_tup. If I
will manually Autovacuum then it's fine.

Can someone help me to solve my request? The below current parameter
setting updated

databaseName=# show autovacuum;
autovacuum
------------
on
(1 row)

databaseName=# show autovacuum_vacuum_threshold;
autovacuum_vacuum_threshold
-----------------------------
50
(1 row)

databaseName=# show autovacuum_vacuum_scale_factor;
autovacuum_vacuum_scale_factor
--------------------------------
0.2
(1 row)

databaseName=# show autovacuum_vacuum_cost_delay;
autovacuum_vacuum_cost_delay
------------------------------
2ms
(1 row)

databaseName=#

databaseName=# /
tblnam | n_dead_tup | pfrag
--------------------------+------------+---------
applicationusername.tablename1 | 52625 | 5262500
applicationusername.tablename2 | 23538 | 2353800
applicationusername.tablename3 | 3290 | 329000
applicationusername.tablename4 | 3092 | 309200
applicationusername.tablename5 | 2262 | 226200
applicationusername.tablename6 | 2110 | 211000
applicationusername.tablename7 | 678 | 67800
applicationusername.tablename8 | 491 | 49100
applicationusername.tablename9 | 431 | 43100
applicationusername.tablenam10 | 351 | 35100
applicationusername.tablenam11 | 188 | 18800
applicationusername.tablenam12 | 150 | 15000

--
Thanks & Regards,
Jayakumar.S
+91-9840864439.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2024-04-03 10:30:17 Trigger
Previous Message Laurenz Albe 2024-04-03 06:24:47 Re: Postgresql - Pgbouncer Connection and Query Performance Problem