"Hugo <Nabble>" <hugo.tech@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
