Re: SSD performance - Mailing list pgsql-performance

From James Mansion
Subject Re: SSD performance
Date
Msg-id 497EABB3.1050903@mansionfamily.plus.com
Whole thread Raw
In response to Re: SSD performance  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: SSD performance
List pgsql-performance
Craig Ringer wrote:
> These devices would be interesting for a few uses, IMO. One is temp
> table space and sort space in Pg. Another is scratch space for apps
> (like Photoshop) that do their own VM management. There's also potential
>
Surely temp tables and sort space isn't subject to fsync and won't gain
that much since they
should stay in the OS cache?  The device will surely help seek- or
sync-bound tasks.

Doesn't that make it a good candidate for WAL and hot tables?

James


pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: [PERFORMANCE] Buying hardware
Next
From: david@lang.hm
Date:
Subject: Re: SSD performance