Re: Thousands of schemas and ANALYZE goes out of memory

"Hugo <Nabble>" <hugo.tech@gmail.com> writes:
> We use Debian linux 32-bits, so the addressable space available really seems
> to be in the 3.0Gb to 3.5Gb range. Last night I decreased the shared_buffers
> from 2Gb to 1Gb and tried the global ANALYZE again. It went out of memory
> after 3 hours 40 minutes. That database has 12,197 schemas with 22 tables
> each, which means 268,334 tables.

It sure sounds to me like you're using the schema for what ought to be a
high-order key column in a much smaller number of tables ... having that
many tables is simply never going to perform well.  We can play
whack-a-mole on individual bottlenecks all day, but that's never going
to fix the fundamental problem.  Some of the bottlenecks will be at
kernel or filesystem level and thus out of our reach, anyway.

            regards, tom lane