Re: Inserting 26 million rows takes 8 hours, how to improve those times?

Jose Vicente Nunez Z <josevnz(at)newbreak(dot)com> writes:
> create table mytable
> (
> a varchar(20) not null,
> b varchar(20) not null,
> c varchar(20) not null,
> d char(6),
> f int null,
> g float not null,
> h float not null
> )

> recreating the original index takes forever:

> create index myindex on mytable ( a, b, c );

> For some reason i don't see much I/O but a lot of CPU ussage:

Hm. I'll bet that you are using a non-C locale, such that varchar
comparisons depend on strcoll() instead of strcmp(). strcoll can
be incredibly slow in some locales. Do you really need non-ASCII
sort order? If not, I'll bet that re-initdb'ing in C locale will
make a difference.

regards, tom lane