Re: 7.3.4 vacuum/analyze error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.3.4 vacuum/analyze error
Дата
Msg-id 9602.1096516451@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7.3.4 vacuum/analyze error  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: 7.3.4 vacuum/analyze error
Список pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> The table has 3 columns, one of which contains huge text values.  Yes, barf.

That shouldn't matter --- ANALYZE actually deliberately ignores
very-wide values so as not to run out of memory.

You sure you haven't changed default_statistics_target?

I'd think you'd uncovered a memory leak in ANALYZE, except that somebody
else would have found any such thing before now.  Which PG version are
you using exactly?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeffrey Melloy
Дата:
Сообщение: Out of memory errors on OS X
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Out of memory errors on OS X