Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

21
  • 1
    Would you agree that the write penalty from RAID 5/6 is somewhat mitigated if good quality SSDs are used? Obviously there is still a penalty, but I think the difference is far less painful than it is with HDDs. Commented May 29, 2014 at 20:09
  • 1
    I haven't tested that. I'd say it's probably less bad - the nasty write amplification effects and (for small writes) need for a read-modify-write cycle still exist, but the severe penalty for excessive seeking should be a non-issue. Commented May 30, 2014 at 0:09
  • Can we just disable indexes instead of dropping them, for example, by setting indisvalid (postgresql.org/docs/8.3/static/catalog-pg-index.html) to false, then load data and then bring indexes online by REINDEX? Commented Dec 10, 2014 at 9:35
  • 2
    @CraigRinger I've tested RAID-5 vs RAID-10 with SSD's on a Perc H730. RAID-5 is actually faster. Also it might be worth noting that insert/transactions in combination with large bytea's seems to be faster than copy. Overall good advice though. Commented Dec 1, 2015 at 12:22
  • 2
    Anyone is seeing any major speed improvements with UNLOGGED? A quick test shows something like 10-20% improvement. Commented Feb 6, 2017 at 23:25