Re: createing indexes on large tables and int8

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Janning Vygen <vygen(at)planwerk6(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: createing indexes on large tables and int8
Date: 2007-07-16 14:19:14
Message-ID: 12217.1184595554@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2007-07-16 14:58:56 Re: unconvertable characters
Previous Message Michael Fuhr 2007-07-16 14:19:10 Re: unconvertable characters