From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
---|---|
To: | Christiaan Willemsen <cwillemsen(at)technocon(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Using high speed swap to improve performance? |
Date: | 2010-04-05 14:55:10 |
Message-ID: | 4BB9F9CE.1020106@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Christiaan Willemsen wrote:
>
> So I was thinking: Why not make a big fat array using 14 disks (raid
> 1, 10 or 5), and make this a big and fast swap disk. Latency will be
> lower than the SAN can provide, and throughput will also be better,
> and it will relief the SAN from a lot of read iops.
>
Presuming that swap will give predictable performance as things go into
and out of there doesn't sound like a great idea to me. Have you
considered adding that space as a tablespace and setting
temp_tablespaces to point to it? That's the best thing I can think of
to use a faster local disk with lower integrity guarantees for.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2010-04-05 16:10:57 | Re: Huge table searching optimization |
Previous Message | hubert depesz lubaczewski | 2010-04-05 14:32:44 | Re: Huge table searching optimization |