Feedback-ID: ia2694551:Fastmail
Date: Tue, 3 Dec 2024 11:38:45 +0100
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: Yuya Watari <watari.yuya@gmail.com>, 
	Dmitry Dolgov <9erthalion6@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>, 
	jian he <jian.universality@gmail.com>, Alena Rybakina <lena.ribackina@yandex.ru>, 
	Andrei Lepikhov <a.lepikhov@postgrespro.ru>, David Rowley <dgrowleyml@gmail.com>, Thom Brown <thom@linux.com>, 
	Zhang Mingli <zmlpostgres@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [PoC] Reducing planning time when tables have many partitions
Message-ID: <202412031038.zrosgbzsoutg@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CAExHW5uVT9kNc0+RBs7eg82+vR5Tuyy34yXKegLPqmrSsJ=1Kg@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/202412031038.zrosgbzsoutg%40alvherre.pgsql>
Precedence: bulk

Hello,

On 2024-Dec-03, Ashutosh Bapat wrote:

> For one of the earlier versions, I had reported a large memory
> consumption in all cases and increase in planning time for Assert
> enabled builds. How does the latest version perform in those aspects?

I don't think planning time in assert-enabled builds is something we
should worry about, at all.  Planning time in production builds is the
important one.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Learn about compilers. Then everything looks like either a compiler or
a database, and now you have two problems but one of them is fun."
            https://twitter.com/thingskatedid/status/1456027786158776329