Re: createing indexes on large tables and int8

Janning Vygen <vygen@planwerk6.de> writes:
> After this i create the index and it took 10 hours just for one index (primary
> key). I have 100.000.000 rows with one PK (int8), two integer data values,
> and two FK (int8)

What PG version is this?  We did a fair amount of work on sort speed
for 8.2.

            regards, tom lane