Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > CREATE INDEX on a 1,8B row table (5 int columns - index created on the > first row about 300M distinct values):
> before: 11h 51min > after: 3h 11min(!) Cool. Does it seem to be I/O bound now? Would you be willing to do it over with oprofile turned on? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend