Postgres Pro
Downloads
Home   >   mailing lists

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

From Ricardo Humphreys
Subject Avoid using swap in a cluster
Date
Msg-id 3aa4c10905090118046e81b107@mail.gmail.com
Whole thread Raw
Responses Re: Avoid using swap in a cluster  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Tree view
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?
 
Thank you,
Ricardo.
 

pgsql-performance by date:

Previous
From: alison@mirrabooka.com (Alison Winters)
Date:
Subject: Re: lots of updates on small table
Next
From: Mark Kirkwood
Date:
Subject: Re: Massive performance issues