Janning Vygen <vygen(at)planwerk6(dot)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