Re: 121+ million record table perf problems

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