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
In response to
pgsql-performance by date
|Next:||From: Y Sidhu||Date: 2007-05-18 23:26:05|
|Subject: Re: pg_stats how-to?|
|Previous:||From: Tyrrill, Ed||Date: 2007-05-18 23:16:20|
|Subject: Re: Slow queries on big table |