Re: What's the best way to use a Solid State HDD?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What's the best way to use a Solid State HDD?
Date: 2004-08-17 15:50:42
Message-ID: 5037.1092757842@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Chris Gamache <cgg007(at)yahoo(dot)com> writes:
> What would you do if you had a solid state hdd to use and you wanted
> to speed up PostgreSQL?

"Put WAL on it" is certainly the default answer.

If you are mainly concerned about speeding up writes, then this is also
the correct answer. If you are mainly worried about read performance
then you might instead investigate pushing some critical tables/indexes
onto it.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Gibson 2004-08-17 15:53:16 Re: [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in
Previous Message Gaetano Mendola 2004-08-17 15:21:59 Re: What's the best way to use a Solid State HDD?