Re: High update activity, PostgreSQL vs BigDBMS

From: Arnau <arnaulist(at)andromeiberica(dot)com>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High update activity, PostgreSQL vs BigDBMS
Date: 2006-12-29 14:26:15
Message-ID: 45952587.5060603@andromeiberica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

> A= go through each query and see what work_mem needs to be for that
> query to be as RAM resident as possible. If you have enough RAM, set
> work_mem for that query that large. Remember that work_mem is =per
> query=, so queries running in parallel eat the sum of each of their
> work_mem's.

How can I know what work_mem needs a query needs?

Regards
--
Arnau

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2006-12-29 17:28:49 Re: Backup/Restore too slow
Previous Message Ron 2006-12-29 12:52:59 Re: High update activity, PostgreSQL vs BigDBMS