Thanks Justin for prompt response. Could you please provide the full email for
pgsql-user? pgsql-u...@postgresql.org<mailto:pgsql-u...@postgresql.org> is not
working
From: Justin Pryzby
Date: Tuesday, 15 November 2022 at 9:02 PM
To: Karthik Jagadish (kjagadis)
Cc: pgsql-hack...@postgres
Hi,
We notice that vacuum is happening at regular intervals but the space occupied
by indexes is always increasing. Any pointers as to why would this happen?
Some outputs below. Auto vacuum is enabled but we notice index size is growing.
$ psql -U postgres -d cgms -c "SELECT
I didn’t get your point dead tuples are visible to transaction means? Vacuuming
job is to remove dead tuples right?
Regards,
Karthik
From: Amul Sul
Date: Tuesday, 8 November 2022 at 6:39 PM
To: Karthik Jagadish (kjagadis)
Cc: pgsql-hack...@postgresql.org , Prasanna
Satyanarayanan (prassaty
?
Regards,
Karthik
From: Amul Sul
Date: Tuesday, 8 November 2022 at 5:38 PM
To: Karthik Jagadish (kjagadis)
Cc: pgsql-hack...@postgresql.org , Prasanna
Satyanarayanan (prassaty) , Chandruganth Ayyavoo Selvam
(chaayyav) , Jaganbabu M (jmunusam)
Subject: Re: Tables not getting vacuumed in postgres
Hi,
We have a NMS application where we are using postgres as database, what we are
noticing is that vacuuming is not happening for certain tables for 2-3 days and
eventually the table bloats and disk space is running out.
What could be the reason for auto vacuuming not happening for certain
]
VACUUM waiting
postgres 18437 62646 0 Jul27 ?00:00:00 postgres: postgres cgms [local]
VACUUM waiting
Regards,
Karthik
From: Julien Rouhaud
Date: Monday, 7 November 2022 at 7:06 PM
To: Laurenz Albe
Cc: Karthik Jagadish (kjagadis) , Dave Page
, pgsql-hack...@postgresql.org
, Chandruganth
lock is present in the table/db or any other reason?
Regards,
Karthik
From: Dave Page
Date: Monday, 7 November 2022 at 5:17 PM
To: Karthik Jagadish (kjagadis)
Cc: pgsql-hack...@postgresql.org , Chandruganth
Ayyavoo Selvam (chaayyav) , Prasanna Satyanarayanan
(prassaty) , Jaganbabu M (jmunusam
Hi,
We have a NMS application in cisco and using postgres as a database.
We have query related to disabling auto vacuum. We have below configuration in
postgres.conf where the autovacuum=on is commented out.
[Shape Description automatically generated]
But when checked in database we notice