From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | ohp(at)pyrenet(dot)fr |
Cc: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Index creation takes for ever |
Date: | 2003-08-28 16:19:13 |
Message-ID: | 24945.1062087553@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
ohp(at)pyrenet(dot)fr writes:
> I've reinitdb (on 7.4b) with LANG=C and it worked.
> So I reinitDB with LANG=FR and used LANG=C to psql -f xxx.sql template1 to
> recreate the db and it worked too...
That's weird. I don't understand why an initdb in the same locale would
make the problem go away.
> I did'nt initdb between cvs changes, maybe that's why.
If you had only seen the problem in 7.4b then I could believe that theory,
but since you also saw it in the stable 7.3 installation, I don't.
> would LANG=C psql -c"reindex table blah" db would help?
No, the LANG environment of psql wouldn't make the slightest difference
here.
I don't think you told us your platform? (OS version, kernel, compiler,
etc)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-08-28 16:19:53 | Re: Hardware recommendations to scale to silly load |
Previous Message | Tom Lane | 2003-08-28 16:13:33 | Re: bug with constraint dependencies? or bug with |
From | Date | Subject | |
---|---|---|---|
Next Message | ohp | 2003-08-28 16:57:02 | Re: Index creation takes for ever |
Previous Message | ohp | 2003-08-28 14:53:18 | Re: Index creation takes for ever |