Re: Avoid using swap in a cluster

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Avoid using swap in a cluster
Дата
Msg-id 43181EA3.3010302@archonet.com
обсуждение исходный текст
Ответ на Avoid using swap in a cluster  (Ricardo Humphreys <ricardoainati@gmail.com>)
Ответы Re: Avoid using swap in a cluster  (Alex Stapleton <alexs@advfn.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Akshay Mathur"
Дата:
Сообщение: Re: Massive performance issues
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Update is more affected( taking more time) than Select