does slony use work_mem?

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: does slony use work_mem?
Date: 2011-07-27 14:09:24
Message-ID: CAHnozThm1PpRpXQYL+3Or-sANk8CYUyb+CA8Vdab71-PstZQ9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Does slony use work_mem?
We are considering to limit work_mem on a per task basis so that
demanding tasks can get more with a low risk of entering SWAP.

(work_mem is used for:
ORDER BY, DISTINCT, merge joins, hash joins, hash-based aggregation,
and hash-based processing of IN subqueries. )

Cheers,

WBL

--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2011-07-27 14:19:33 Re: Implementing "thick"/"fat" databases
Previous Message Merlin Moncure 2011-07-27 14:01:54 Re: Implementing "thick"/"fat" databases