Postgres Pro
Downloads
Home   >   mailing lists

Re: What's the best way to use a Solid State HDD? - Mailing list pgsql-admin

From Tom Lane
Subject Re: What's the best way to use a Solid State HDD?
Date
Msg-id 5037.1092757842@sss.pgh.pa.us
Whole thread Raw
In response to What's the best way to use a Solid State HDD?  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
Tree view 
Chris Gamache <cgg007@yahoo.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

pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: What's the best way to use a Solid State HDD?
Next
From: Mark Gibson
Date:
Subject: Re: [PHP] Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in