Поиск
Список
Период
Сортировка
Искать

От:
Jean-Max Reymond <jmreymond@gmail.com>
Дата:
-- 
Jean-Max Reymond
CKR Solutions
http://www.ckr-solutions.com

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

От:
Chris Gamache <cgg007@yahoo.com>
Дата:
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!
http://promotions.yahoo.com/new_mail

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

От:
Gaetano Mendola <mendola@bigfoot.com>
Дата:
Chris Gamache wrote:

> I'm using a TiGiJet 2GB Solid State drive. 

How much it cost ?

> 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?

Depend what do you want obtain.
Do you want speed up writes ?
Are you annoyed by a full scan table that you can not avoid ?
or what ?



Regards
Gaetano Mendola




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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Chris Gamache  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
FAQ