Postgres Pro
Downloads
Home   >   mailing lists

Re: High update activity, PostgreSQL vs BigDBMS - Mailing list pgsql-performance

From Arnau
Subject Re: High update activity, PostgreSQL vs BigDBMS
Date
Msg-id 45952587.5060603@andromeiberica.com
Whole thread Raw
In response to Re: High update activity, PostgreSQL vs BigDBMS  (Ron <rjpeace@earthlink.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: High update activity, PostgreSQL vs BigDBMS
Next
From: Sebastián Baioni
Date:
Subject: Backup/Restore too slow