Avoid using swap in a cluster - Mailing list pgsql-hackers

From Ricardo Humphreys
Subject Avoid using swap in a cluster
Date
Msg-id 3aa4c109050901181147333db1@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hi.
 
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?
 
Thank you,
Ricardo.
 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pre-allocated free space for row
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: PL/pgSQL: EXCEPTION NOSAVEPOINT