From: Richard Huxton <dev@archonet.com>
To: Ricardo Humphreys <ricardoainati@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Avoid using swap in a cluster
Date: Fri, 02 Sep 2005 10:42:59 +0100
Message-ID: <43181EA3.3010302@archonet.com> (raw)
In-Reply-To: <3aa4c10905090118046e81b107@mail.gmail.com>
References: <3aa4c10905090118046e81b107@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, ricardoainati@gmail.com
Subject: Re: Avoid using swap in a cluster
In-Reply-To: <43181EA3.3010302@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox