Janning Vygen <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend