Temp files and process memory footprint

From: Erik Jones <ejones(at)engineyard(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Temp files and process memory footprint
Date: 2013-05-06 20:03:47
Message-ID: 8683AA87-0D43-43E9-806B-13CDCB83D767@engineyard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Looking to start collecting what memory usage I can via logging with an eye towards establishing typical usage profiles for different users (i.e. app, reporting, etc.) and hopefully later gaining the ability to kill extreme outliers when they hit.

So, would the temp file size logged via log_temp_files have contributed to the process's (Linux) resident memory size while the query responsible was running?

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2013-05-06 23:43:03 Re: "Unlogged indexes"
Previous Message Merlin Moncure 2013-05-06 16:24:24 Re: Simple SQL INSERT to avoid duplication failed: why?