Hello Team,
We are on postgres 9.6 and we have a script that runs to analyze over
5000 databases on over 600 servers. Our maintenance work_mem is set to
128MB but
When script runs, maintenance work_mem is set on session level to 2GB
and the memory on the server is 32GB.
We are getting this below error on some table columns
ERROR: invalid memory alloc request size 8589934668
I saw a ticket which one of my co-worker had to alter the columns to
disable statistic collection and also update the storage by using
these two commands .
ALTER COLUMN position SET STATISTICS 0;
ALTER COLUMN position SET STORAGE EXTENDED;
Can someone assist me on how to go about this because seeing
statistics disabled on the column is not a good idea if queries are
actually using the columns .
Regards
Roland Che.