Allan Kamau wrote:
I am now thinking of investing in a SSD (Solid State Drive), and maybe
choosing between Crucial Technology 256GB Crucial M225 Series
2.5-Inch Solid State Drive (CT256M225) and Intel X25-M G2 (160GB) -
Intel MLC.
Both of these are worthless for database applications if you
On Thu, Nov 11, 2010 at 4:35 PM, Vick Khera vi...@khera.org wrote:
On Thu, Nov 11, 2010 at 1:42 AM, Allan Kamau kamaual...@gmail.com wrote:
After googling I found little resent content (including survival
statistics) of using SSDs in a write intensive database environment.
We use the Texas
Postgres General
Subject: [GENERAL] Considering Solid State Drives
Hi,
As part of datamining activity. I have some plpgsql functions
(executed in parallel, up to 6 such concurrent calls) that perform
some reads and writes of large number of (maybe 1) records at a
time to a table having multi
On Thu, Nov 11, 2010 at 1:42 AM, Allan Kamau kamaual...@gmail.com wrote:
After googling I found little resent content (including survival
statistics) of using SSDs in a write intensive database environment.
We use the Texas Memory RAMSan-620 external disk units. It is
designed specifically to
Hello,
When choosing SSD drive you need to consider
* number of writes to particular sector which is about 100k to 200k and then
sector will fail
* in case of DB grow, limitied size of those dirvers.
As part of datamining activity. I have some plpgsql functions
(executed in parallel, up to 6
ZFS has an option to use an SSD as cache for the spinning drives. ZFS
under Solaris has turned in some really good IO numbers. The problem is
with the new Sun I am not feeling so good about the open nature of
Solaris. ZFS performance under BSD I have read does not match ZFS under
Solaris.
On
Am 11.11.2010 16:40, schrieb David Siebert:
ZFS has an option to use an SSD as cache for the spinning drives. ZFS
under Solaris has turned in some really good IO numbers. The problem is
with the new Sun I am not feeling so good about the open nature of
Solaris. ZFS performance under BSD I have
:42 PM
To: Postgres General Postgres General
Subject: [GENERAL] Considering Solid State Drives
Hi,
As part of datamining activity. I have some plpgsql functions
(executed in parallel, up to 6 such concurrent calls) that perform
some reads and writes of large number of (maybe 1) records
Hi,
As part of datamining activity. I have some plpgsql functions
(executed in parallel, up to 6 such concurrent calls) that perform
some reads and writes of large number of (maybe 1) records at a
time to a table having multi-column primary key.
It seems the writing of these few thousands