Re: 7.3.4 vacuum/analyze error
От | Tom Lane |
---|---|
Тема | Re: 7.3.4 vacuum/analyze error |
Дата | |
Msg-id | 8854.1096513154@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: >> Either increase your per-process memory limit, or reduce the statistics >> targets for this table ... > What am I missing? > $ ulimit -a > time(seconds) unlimited > file(blocks) unlimited > data(kbytes) 131072 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ This is where the limit is coming from ... > $ psql -c "select name, setting from pg_settings" | egrep stats_ > stats_block_level | off Those are not the statistics I'm talking about. I was assuming that you'd done ALTER TABLE SET STATISTICS somewhere along the line, or changed default_statistics_target. If you haven't, then this must be a pretty strange table --- how many columns has it got? regards, tom lane
В списке pgsql-general по дате отправления: