Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoid using swap in a cluster - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Avoid using swap in a cluster
Date
Msg-id 43181EA3.3010302@archonet.com
Whole thread Raw
In response to Avoid using swap in a cluster  (Ricardo Humphreys <ricardoainati@gmail.com>)
Responses Re: Avoid using swap in a cluster  (Alex Stapleton <alexs@advfn.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Akshay Mathur"
Date:
Subject: Re: Massive performance issues
Next
From: Richard Huxton
Date:
Subject: Re: Update is more affected( taking more time) than Select