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.
