On Mon, Sep 21, 2009 at 10:47 AM, Alan McKay <alan.mckay@xxxxxxxxx> wrote: > 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? I'm not sure what to suggest, other than the available operating system tools, but if you post EXPLAIN ANALYZE output we might be able to speculate better. Setting work_mem too high is a frequent cause of problems of this sort, I think. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance