Avoid using swap in a cluster

Avoid using swap in a cluster

This is a discussion on Avoid using swap in a cluster within the pgsql Hackers forums, part of the PostgreSQL category; --> Hi. In a cluster, is there any way to use the main memory of the other nodes instead of ...

		Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers
Avoid using swap in a cluster

#1 (permalink)

04-11-2008, 05:33 AM

Ricardo Humphreys

Posts: n/a

Avoid using swap in a cluster

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.

« Re: Pre-allocated free space for row updating (like PCTFREE) | Re: PL/pgSQL: EXCEPTION NOSAVEPOINT »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 10:50 PM.