From 48f1c1feda91d9809406c83569443eedc9ea799e Mon Sep 17 00:00:00 2001
From: Karen Arutyunov <karen@codesynthesis.com>
Date: Fri, 14 Jul 2023 22:27:02 +0300
Subject: Optimize builds page by discouraging PostgreSQL from using the nested
 loop join strategy

---
 monitor/monitor.cxx | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'monitor')

diff --git a/monitor/monitor.cxx b/monitor/monitor.cxx
index 05ebf9d..126650c 100644
--- a/monitor/monitor.cxx
+++ b/monitor/monitor.cxx
@@ -853,6 +853,11 @@ namespace brep
                   {
                     package_config_name = pc.name;
 
+                    // @@ TMP Check if we can optimize this query by adding
+                    //        index for soft_timestamp and/or by setting
+                    //        enable_nestloop=off (or some such) as we do in
+                    //        mod/mod-builds.cxx.
+                    //
                     auto pbs (pbq.execute ());
 
                     if (!pbs.empty ())
-- 
cgit v1.1