The PostgreSQL version is 9.6.
I dont have access to the machine right now so I will check tomorrow.
Basically those values should be the same because they are updated by the
autovacuum process right ?
Any idea what else to check ? During the week last_autovacuum (in
pg_stat_all_tables) were
On Wed, Mar 06, 2019 at 06:47:21PM +0200, Mariel Cherkassky wrote:
> Those settings helped but the table still grey very much. I wrote a script
> that monitored some metadata about the table (pg_stat_all_tables,count(*)
> from orig and toasted table). I let the system monitor the table for a week
Hi,
I have the next relation in my db : A(id int, info bytea,date timestamp).
Every cell in the info column is very big and because of that there is a
toasted table with the data of the info column (pg_toast.pg_toast_123456).
The relation contains the login info for every user that logs into the