Re: [HACKERS] VACUUM ANALYZE problem on linux - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] VACUUM ANALYZE problem on linux
Date
Msg-id 28148.919953236@sss.pgh.pa.us
Whole thread Raw
In response to RE: [HACKERS] VACUUM ANALYZE problem on linux  (Oleg Broytmann <phd@sun.med.ru>)
Responses 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] postmaster failure with 2-23 snapshot
Next
From: Oleg Broytmann
Date:
Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux