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