Skip site navigation (1) Skip section navigation (2)

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

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: What's the best way to use a Solid State HDD?
Date: 2004-08-17 14:48:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I'm using a TiGiJet 2GB Solid State drive. My thought was to place the WAL on
it to speed up writes. I don't know of any tools that exist to determine the
effectiveness of this except for anecdotal analysis (This type of query took 3
minutes yesterday, and 1 minute today) ... Sar gives me machine-wide stats, but
we do more than PostgreSQL here. I can enable stats, but will that tell me what
I'm looking for?

Vmstat reports no swapping of pages of ram to disk, so I don't think it would
make sense to make it a Linux Swap drive.

I suppose I could move some actual tables and indexes to the device.
Tablespaces might make this easy. I'm still using 7.4.3. If I had to pick
between tables and indexes, which would make more sense to put on the
solid-state device?

What would you do if you had a solid state hdd to use and you wanted to speed
up PostgreSQL?

Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!

In response to

  • at 2004-08-17 12:54:48 from Jean-Max Reymond


pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-08-17 15:21:59
Subject: Re: What's the best way to use a Solid State HDD?
Previous:From: Mark GibsonDate: 2004-08-17 14:40:02
Subject: Kerberos, Apache2, mod_auth_kerb, PHP, and PostgreSQL in harmony! How?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group