Re: When/if to Reindex - Mailing list pgsql-performance

From Steven Flatt
Subject Re: When/if to Reindex
Date
Msg-id 357fa7590708090651p71b9bc47n66739f8dbbb4ff57@mail.gmail.com
Whole thread Raw
In response to Re: When/if to Reindex  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: When/if to Reindex  ("Steven Flatt" <steven.flatt@gmail.com>)
List pgsql-performance
On 8/8/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
I'd make the same remark about Steven's case: if possible, don't create
the indexes at all until you've loaded the table fully.
 
We considered this, however in some of our 12-hour partitions, there are upwards of 50 or 60 million rows near the end of the 12 hours so read performance gets bad on the current partition very quickly if there are no indexes.
 
It makes more sense for us to have ~1 hour's worth of reindexing afterwards during which read performance on that partition is "compromised".
 
Steve
 

pgsql-performance by date:

Previous
From: "Trevor Talbot"
Date:
Subject: Re: Update table performance
Next
From: Vivek Khera
Date:
Subject: Re: mid 2007 "best bang for the buck" hardware opinions