From: Hari Babu <haribabu.kommi@huawei.com>
To: pgsql-performance@postgresql.org
Subject: Memory issue for inheritance tables.
Date: Thu, 13 Dec 2012 10:22:12 +0530
Message-ID: <004501cdd8ed$9e194f40$da4bedc0$@kommi@huawei.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: haribabu.kommi@huawei.com
Subject: Re: Memory issue for inheritance tables.
In-Reply-To: <004501cdd8ed$9e194f40$da4bedc0$@kommi@huawei.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox