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 по дате отправления: