Postgres Pro
Downloads
Home   >   mailing lists

query memory consumption - Mailing list pgsql-performance

From Alan McKay
Subject query memory consumption
Date
Msg-id 844129e80909210747y6a69ecaehcc351c773587e3da@mail.gmail.com
Whole thread Raw
Responses Re: query memory consumption
Re: query memory consumption
List pgsql-performance
Tree view 
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"

pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Index row requires 9324 bytes maximum size is 8191
Next
From: Merlin Moncure
Date:
Subject: Re: slow query : very simple delete, 100% cpu, nearly no disk activity