On 1/25/2017 12:59 PM, Thomas Kellerer wrote:
So here is my question: how does Postgres estimate/know the memory needed for the aggregation? Or does it dynamically resize the memory if the initial assumption was wrong?
my understanding is it fits as much as it can into a work_mem sized allocation, and if thats not enough uses temporary files and multiple passes.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
