Re: [HACKERS] VACUUM ANALYZE problem on linux

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] VACUUM ANALYZE problem on linux
Дата
Msg-id 28148.919953236@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] VACUUM ANALYZE problem on linux  (Oleg Broytmann <phd@sun.med.ru>)
Ответы Re: [HACKERS] VACUUM ANALYZE problem on linux  (Oleg Broytmann <phd@sun.med.ru>)
Re: [HACKERS] VACUUM ANALYZE problem on linux  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Say, is it possible that your VACUUM problem is a locale-related bug?

If init runs with a different locale setting than hand-started
processes, then that would affect index ordering ... which could
perhaps cause fatal problems while vacuuming indexes.  I could
believe that VACUUM is not able to cope with indexes that appear
to be out of order according to the sort operators it's using.

This line of thought leads to the idea that indexes had better be
marked explicitly with the locale that they're for.  Or else we
need to change Postgres so that the locale setting is hard-wired
at compile time and not dependent on environment variables.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] postmaster failure with 2-23 snapshot
Следующее
От: Oleg Broytmann
Дата:
Сообщение: Re: [HACKERS] VACUUM ANALYZE problem on linux