Re: Avoid using swap in a cluster

From: Richard Huxton <dev(at)archonet(dot)com>
To: Ricardo Humphreys <ricardoainati(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Avoid using swap in a cluster
Date: 2005-09-02 09:42:59
Message-ID: 43181EA3.3010302@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ricardo Humphreys wrote:
> Hi all.
> In a cluster, is there any way to use the main memory of the other nodes
> instead of the swap? If I have a query with many sub-queries and a lot of
> data, I can easily fill all the memory in a node. The point is: is there any
> way to continue using the main memory from other nodes in the same query
> instead of the swap?

I don't know of any clustered version of PG that can spread queries over
multiple machines. Can I ask what you are using?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2005-09-02 09:48:11 Re: Update is more affected( taking more time) than Select
Previous Message Akshay Mathur 2005-09-02 09:23:58 Re: Massive performance issues