Craig James wrote: > Better yet, if you can stand a short down time, you can drop indexes on > that column, truncate, then do 121 million inserts, and finally > reindex. That will be MUCH faster.
Or you can do a CLUSTER, which does all the same things automatically. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
