Re: [HACKERS] VACUUM ANALYZE problem on linux

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: phd2(at)earthling(dot)net
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] VACUUM ANALYZE problem on linux
Date: 1999-02-25 14:33:56
Message-ID: 28148.919953236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Broytmann 1999-02-25 14:40:50 Re: [HACKERS] VACUUM ANALYZE problem on linux
Previous Message Tom Lane 1999-02-25 14:28:41 Re: [HACKERS] postmaster failure with 2-23 snapshot