Memory issue for inheritance tables.

From: Hari Babu <haribabu(dot)kommi(at)huawei(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Memory issue for inheritance tables.
Date: 2012-12-13 04:52:12
Message-ID: 004501cdd8ed$9e194f40$da4bedc0$@kommi@huawei.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

One parent table, having 100 child tables.
In this scenario we observed that delete and update are taking more memory
for preparing a plan

If the system under peak i am getting out of memory issue.

i.e
Select on parent table is using memory - 331456 in message context
Delete on parent table is using memory - 3746432 in message context

Delete on single child table is using memory - 8800 in message context
Select on single child table is using memory - 9328 in message context

For 250 child tables
Select on parent table is using memory - 810864 in message context

Delete on parent table is using memory - 21273088 in message context

I had seen the plans for both delete & select on parent table almost same.
why this much of memory increase in message context for delete and update
operation.

Regards,
Hari babu.

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2012-12-13 09:40:40 Re: [PERFORM] encouraging index-only scans
Previous Message Pavan Deolasee 2012-12-13 04:48:48 Re: [PERFORM] encouraging index-only scans