Postgres Pro
Downloads
Home   >   mailing lists

Re: createing indexes on large tables and int8 - Mailing list pgsql-general

From Tom Lane
Subject Re: createing indexes on large tables and int8
Date
Msg-id 12217.1184595554@sss.pgh.pa.us
Whole thread Raw
In response to createing indexes on large tables and int8  (Janning Vygen <vygen@planwerk6.de>)
Responses Re: createing indexes on large tables and int8  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Re: createing indexes on large tables and int8  (mljv@planwerk6.de)
List pgsql-general
Tree view 
Janning Vygen <vygen@planwerk6.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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: unconvertable characters
Next
From: Sim Zacks
Date:
Subject: Re: unconvertable characters