Re: Thousands of schemas and ANALYZE goes out of memory - Mailing list pgsql-general

"Hugo <Nabble>" <hugo.tech@gmail.com> writes:
> We have two postgresql 9.0 databases (32-bits) with more than 10,000
> schemas. When we try to run ANALYZE in those databases we get errors like
> this (after a few hours):

> 2012-09-14 01:46:24 PDT ERROR:  out of memory
> 2012-09-14 01:46:24 PDT DETAIL:  Failed on request of size 421.
> 2012-09-14 01:46:24 PDT STATEMENT:  analyze;

I doubt that the number of *schemas* is a big deal here, but the number
of *tables* might well be.  How many?  Also, 9.0.what?

            regards, tom lane