How exactly PostgreSQL allocates memory for its needs?

From: Anton Maksimenkov <anton200(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How exactly PostgreSQL allocates memory for its needs?
Date: 2010-02-10 05:10:36
Message-ID: 8cac8dd1002092110q45411eb1j63bc1b3ce40f3d2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Can anybody briefly explain me how each postgres process allocate
memory for it needs?
I mean, what is the biggest size of malloc() it may want? How many
such chunks? What is the average size of allocations?

I think that at first it allocates contiguous piece of shared memory
for "shared buffers" (rather big, hundreds of megabytes usually, by
one chunk).
What next? temp_buffers, work_mem, maintenance_work_mem - are they
allocated as contiguous too?
What about other needs? By what size they are typically allocated?
--
antonvm

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2010-02-10 05:49:24 Re: PostgreSQL - case studies
Previous Message Amitabh Kant 2010-02-10 04:38:37 Re: PostgreSQL - case studies