Horton

Thread

  1. Re: [HACKERS] VACUUM ANALYZE problem on linux

    Tom Lane <tgl@sss.pgh.pa.us> — 1999-02-25T14:33:56Z

    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

  2. Re: [HACKERS] VACUUM ANALYZE problem on linux

    Oleg Broytmann <phd@sun.med.ru> — 1999-02-25T14:40:50Z

    Hi!

On Thu, 25 Feb 1999, Tom Lane wrote:
> Say, is it possible that your VACUUM problem is a locale-related bug?

   Hmm... May be.

> 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.

   I have no indexes in this database.
   Looks like I need toreproduce the same env in command line. I'll try.

Oleg.
---- 
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.

  3. Re: [HACKERS] VACUUM ANALYZE problem on linux

    Angelos Karageorgiou <angelos@awesome.incredible.com> — 1999-02-25T15:41:50Z

    On Thu, 25 Feb 1999, Oleg Broytmann wrote:

> 
>    I have no indexes in this database.
>    Looks like I need toreproduce the same env in command line. I'll try.

why don't you create a sh script to start postgres out off, ans set -x and 
of cource a setenv etc.. Call the _SAME_ file from your init and from your 
command line and diff the results.

-- 
Incredible Networks LTD       Angelos Karageorgiou
20 Karea st,                  +30.1.92.12.312 (voice)
116 36 Athens, Greece.        +30.1.92.12.314 (fax)
http://www.incredible.com     angelos@incredible.com (e-mail)

  4. Re: [HACKERS] VACUUM ANALYZE problem on linux

    Bruce Momjian <maillist@candle.pha.pa.us> — 1999-02-25T17:40:42Z

    > 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.

That is an excellent point.  I never considered that.  In fact, initdb
would also need identical locale, wouldn't it.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

  5. Re: [HACKERS] VACUUM ANALYZE problem on linux

    Ross Reedstrom <reedstrm@rice.edu> — 1999-02-25T18:25:04Z

    Oleg Broytmann wrote:

>    I have no indexes in this database.
>    Looks like I need toreproduce the same env in command line. I'll try.

This (locale of indices) still might be it - the system tables have
indices, which I believe get updated when you VACUUM (in fact, that's
kind of the point)

Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

  6. Re: [HACKERS] VACUUM ANALYZE problem on linux

    Oleg Broytmann <phd@sun.med.ru> — 1999-02-26T10:54:23Z

    Hi!

On Thu, 25 Feb 1999, Ross J. Reedstrom wrote:
> This (locale of indices) still might be it - the system tables have

   I recompiled postgres without locale, run initdb, load my dump - VACUUM
ANALYZE worked :(
   I wonder, what may be wrong with locale support, that trigger only on
glibc2?

Oleg.
---- 
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.