From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Vick Khera <vivek(at)khera(dot)org> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Solid State Drives with PG |
Date: | 2010-04-07 20:43:51 |
Message-ID: | l2qb42b73151004071343y7150626qe45554831f8bf9ff@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
On Wed, Apr 7, 2010 at 3:27 PM, Vick Khera <vivek(at)khera(dot)org> wrote:
> On Fri, Mar 26, 2010 at 3:50 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>> here is a _used_ 320gb ramsan for 15k :-). dram storage is pricey.
>>
>
> I think using DRAM as the base is way better than flash. Just use the
> flash or a regular disk as the backup with a battery to power the
> backup operation.
>
> I have in my storage room a DRAM based SCSI storage device made by
> Imperial Technology. It was totally the bees knees in 2000 when I
> bought it (with 1GB of RAM) for almost $30k. Upgraded a year later to
> 5Gb for another $15k. It has 4 low-profile/offset SCSI-2 connectors
> and full battery backed up UPS internal to it, and writes itself to a
> traditional disk drive on power outage, and continually ran self
> diagnostics to ensure that everything was just right.
>
> Free. But it doesn't power up. Probably needs a cap replaced or
> something simple like that.
dram storage makes sense in some cases but is generally so expensive
that it throws off the whole hardware cost/engineering calculus even
with the insane expense of writing software (even to the 0.0001% of it
managers that understand this). that's saying something.
the idea behind flash storage though was to provide at least decent
performance at a reasonable cost. making dram storage fault tolerant
takes a lot of engineering thus the high cost. as a dba, the idea of
flash being able to be swapped in for sata spinning drives for a
10-20x gain in iops makes me vibrate.
except that the fault tolerance issue isn't worked out yet. so I
continue to buy bulk fossilized dinosaur plop and waste precious time
figuring out how to make it work with otherwise fairly modern
equipment. did i mention that i was annoyed with intel?
check out their faq entry on ssd/write back cache:
Does the Intel SSD have a write cache?
Yes. However data caching is limited to the controller for enhanced performance.
huh!?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2010-04-07 20:54:23 | Re: Solid State Drives with PG |
Previous Message | Vick Khera | 2010-04-07 19:27:02 | Re: Solid State Drives with PG |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2010-04-07 20:53:30 | Re: Internal PG functions, how to pass proper parameters? |
Previous Message | Tuo Pe | 2010-04-07 20:28:04 | Re: Problem either with PostgreSQL or with PHP (SOLVED!) |