Postgres Pro
Downloads
Home   >   mailing lists

Re: 121+ million record table perf problems - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: 121+ million record table perf problems
Date
Msg-id 20070518232052.GG15691@alvh.no-ip.org
Whole thread Raw
In response to Re: 121+ million record table perf problems  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Tyrrill, Ed"
Date:
Subject: Re: Slow queries on big table
Next
From: "Y Sidhu"
Date:
Subject: Re: pg_stats how-to?