Re: Avoid using swap in a cluster

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