There's a handful of hidden columns like Xmin and Xmax per row that you're
not accounting for, header info per page, reserve space, free space... The
physical size on disk is reasonable.
Otherwise you can reduce the number of rows by cleaning up and moving out
old data, reduce the width of each ro
sudo yum install perl-CPAN
Also do a "yum search perl-" and you should find most, if not all what you
need natively packaged for your particular Linux distro. You're better off
just sticking with the pre-packaged perl modules unless you specifically
need something special.
You'll find more modul
My first two guesses are ulimit or numa. numactl --hardware will show your
how many nodes your box has and if you're exhausting any of them.
On Thu, Sep 20, 2018, 6:11 PM greigwise wrote:
> Hello, I'm running postgres 9.6.10 on Centos 7. Seeing the occasional out
> of memory error trying to r
