Janning Vygen <vygen@xxxxxxxxxxxx> 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
