"Hugo <Nabble>" <hugo(dot)tech(at)gmail(dot)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