> We're getting about 64 million rows inserted in about 1.5 hrs into a
> table with a multiple-column primary key - that's the only index.
> That's seems pretty good to me - SQL Loader takes about 4 hrs to do the
> same job.
As I recall, the last time we rebuilt our database, it took about 3 hours to
import 265 million rows of data. It then took another 16 hours to rebuild
all the indexes. I think the entire pg_dumpall/reload process took about 21
hours +/-. I wonder what it will be like with 1.5 billion rows...
Wes
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
