query memory consumption

From: Alan McKay <alan(dot)mckay(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: query memory consumption
Date: 2009-09-21 14:47:46
Message-ID: 844129e80909210747y6a69ecaehcc351c773587e3da@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hey folks,

We are looking to optimize the query I was talking about last week
which is killing our system.

We have explain and analyze which tell us about the cost of a query
time-wise, but what does one use to determine (and trace / predict?)
memory consumption?

thanks,
-Alan

--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vincent de Phily 2009-09-21 14:50:23 Re: slow query : very simple delete, 100% cpu, nearly no disk activity
Previous Message Florian Weimer 2009-09-21 08:51:22 Re: Index row requires 9324 bytes maximum size is 8191