[PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG

From: Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com>
To: pghackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG
Date: 2022-12-25 16:20:16
Message-ID: 1fd8e494-4740-4108-6d06-d5a173836047@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

This is patch for TODO item: /Improve ability to display optimizer
analysis using OPTIMIZER_DEBUG
/

As per as suggestion in the mailing list which is to replace current
mechanism of getting optimizer log via OPTIMIZER_DEBUG macro

to something more configurable (which doesn't require rebuilding
postgres from source code). This patch replaces /OPTIMIZER_DEBUG
/

by introducing a//GUC /show_optimizer_log /which can be configured on
and off to//display (or hide)//previously generated log from stdout to
postmaster's log.

Please check attached patch, any feedback is appreciated.

--
Regards,
Ankit Kumar Pandey

Attachment Content-Type Size
v1-0001-Improve-ability-to-display-optimizer-analysis.patch text/x-patch 15.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-12-25 17:13:26 Re: Error-safe user functions
Previous Message Ankit Kumar Pandey 2022-12-25 13:04:38 Todo: Teach planner to evaluate multiple windows in the optimal order