Re: SSDs with Postgresql?

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SSDs with Postgresql?
Date: 2011-04-18 18:01:59
Message-ID: BANLkTi=r4SMsHw7uDcZO0YYiboD47pBWRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Apr 17, 2011 at 5:17 AM, Henry C. <henka(at)cityweb(dot)co(dot)za> wrote:

> When the super-fast SSD-based machine fails, switching to a (slower)
> standard
> hard-drive based machine provides continuity and buys time while we get the
> primary machine back online.
>

The question you should ask yourself is: can my business run at needed
capacity on the slower spinning media? Our answer was "no", so we ended up
with a second SSD array for the backup server as well. It was *still*
totally worth the metric gazillion dollars that they cost.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shawn Gennaria 2011-04-18 18:02:17 Re: Migrating Data Across Major Versions
Previous Message Tom Lane 2011-04-18 15:15:28 Re: REASSIGN OWNED doesn't for all objects, ALTER FUNCTION seems to fix it