On 2 Sep 2005, at 10:42, Richard Huxton wrote:
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?
IIRC GreenPlums DeepGreen MPP (Version 2) can do it. It does cost
money though, but it is a very nice product.
--
Richard Huxton
Archonet Ltd
---------------------------(end of
broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org