Re: Hardware advice for scalable warehouse db

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware advice for scalable warehouse db
Date: 2011-07-15 18:46:16
Message-ID: 4E208AF8.1070805@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> Just to add to the conversation, there's no real advantage to putting
> WAL on SSD. Indexes can benefit from them, but WAL is mosty
> seqwuential throughput and for that a pair of SATA 1TB drives at
> 7200RPM work just fine for most folks.

Actually, there's a strong disadvantage to putting WAL on SSD. SSD is
very prone to fragmentation if you're doing a lot of deleting and
replacing files. I've implemented data warehouses where the database
was on SSD but WAL was still on HDD.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message chris r. 2011-07-15 18:49:20 Re: Hardware advice for scalable warehouse db
Previous Message Scott Marlowe 2011-07-15 18:01:12 Re: Hardware advice for scalable warehouse db