Re: concurrent IO in postgres?

From: Andy <angelflow(at)yahoo(dot)com>
To: "wozniak(at)lanl(dot)gov" <wozniak(at)lanl(dot)gov>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, John W Strange <john(dot)w(dot)strange(at)jpmchase(dot)com>
Subject: Re: concurrent IO in postgres?
Date: 2010-12-23 19:58:18
Message-ID: 409661.69535.qm@web111313.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


--- On Thu, 12/23/10, John W Strange <john(dot)w(dot)strange(at)jpmchase(dot)com> wrote:

> Typically my problem is that the
> large queries are simply CPU bound..  do you have a
> sar/top output that you see. I'm currently setting up two
> FusionIO DUO @640GB in a lvm stripe to do some testing with,
> I will publish the results after I'm done.
>
> If anyone has some tests/suggestions they would like to see
> done please let me know.
>
> - John

Somewhat tangential to the current topics, I've heard that FusionIO uses internal cache and hence is not crash-safe, and if the cache is turned off performance will take a big hit. Is that your experience?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ben 2010-12-23 20:06:40 encourging bitmap AND
Previous Message Przemek Wozniak 2010-12-23 19:46:57 Re: concurrent IO in postgres?