Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sL1uu-00D8XB-PU
	for pgsql-general@arkaria.postgresql.org; Sat, 22 Jun 2024 14:40:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sL1us-009ZeH-NR
	for pgsql-general@arkaria.postgresql.org; Sat, 22 Jun 2024 14:40:35 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sL1ur-009Ze9-9B
	for pgsql-general@lists.postgresql.org; Sat, 22 Jun 2024 14:40:34 +0000
Received: from fout6-smtp.messagingengine.com ([103.168.172.149])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sL1uj-002a2R-Nh
	for pgsql-general@postgresql.org; Sat, 22 Jun 2024 14:40:31 +0000
Received: from compute6.internal (compute6.nyi.internal [10.202.2.47])
	by mailfout.nyi.internal (Postfix) with ESMTP id 9FBDB1380119;
	Sat, 22 Jun 2024 10:40:23 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute6.internal (MEProxy); Sat, 22 Jun 2024 10:40:23 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1719067223;
	 x=1719153623; bh=Jv3Rp4Npt1auozJ8inJfbqT9alMpapQRPvdM6m+SDz8=; b=
	cTIu585j/+gyMrL3Q7KRen90ynUWkqSd89xoaaR70ITqIHB2/XmhTeDhRhivzrai
	MN5dlKaZ3Un0VVRGVwGSWC61m1zSGJ05OiCq/2ZWZ+aXEjawNlDMNE3QT6OVkzag
	Tb4xoqtuFyR2nIX3Hy8km93a9PL68hKx6RmffpOmcS3CA98IH/QEaj/3Btf1mNPV
	H/fup1gd6Vqq9yf0xjxsqy/X4y9OjdvmUIX/tzqgmOYTgpcBO89vNvGyBI2AZnFd
	Egx0WwbnRHeDrRRLwC8AZhLDh5Hxo18wNwO+KN8t4+tM2t0hSNlu/XhJNPPp+yrY
	0zZw7AOb9gpseL5AATYbmA==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1719067223; x=
	1719153623; bh=Jv3Rp4Npt1auozJ8inJfbqT9alMpapQRPvdM6m+SDz8=; b=B
	4oX9Bx1Xp4QkJWVFvS3TBVokxCdcY52FB/NGLb1sD1lAJo+UsLuggQhHDzBlaCRq
	hIb6t/WZszUmzLlxmjY/WOrvRRhcmIHyyebcIcjDamohQQgqfsOTriNGmH+osXhm
	W0f1AR1qp5UrCOlm7YXJKIjOCN3K6E+qS/TtmKva98+qP5k7dL7+4EqhhRrB2j3n
	XxnDj8DtaWhXMGX4uiuT/OD/SD6NOL9jEQcM8sDCXx+yIQ/6nbml9PD2Sr8znTEx
	bDk5TFFzvXK1ym/MDqcv4+9A/+iIP7d+R/8/pcoGP8vUMpg7QaztqNmI06TkGZn/
	CLYEj/QyY3fEvHMoRsgHg==
X-ME-Sender: <xms:VuJ2Zp61mJ3jjNQ70jVc9MqgzH_jbiRG_uZMiTnYUWkR-U8GCxSH5w>
    <xme:VuJ2Zm5kzwYZEBFwdN-LSKVRgvDAJTlvb6sJfIIGEgxfyZ13H-VhUknEmxN6WEKAP
    _wWMTG_V96FtSg>
X-ME-Received: <xmr:VuJ2ZgfvUCtFI7wL077hFrFUCndcT6vSC1oEZZX44vK6QunpzBTeUpKJOdBuclzxVyPRL6LpL-s-sanPQQO3gTHGMuE>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeefiedgkeduucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhi
    rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh
    hmqeenucggtffrrghtthgvrhhnpefghedtgeeuveekgedtgeeuudehgffhuddvuefgheeg
    ieegfeegveetgfdvieeugfenucffohhmrghinhepvhhishgvnhgrrdgtohhmnecuvehluh
    hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhk
    lhgrvhgvrhesrghklhgrvhgvrhdrtghomh
X-ME-Proxy: <xmx:VuJ2ZiJ8jdksB_dY9-npT6F5ysTlsbP1PHeRYvMqbgRChMOkgwwqdw>
    <xmx:V-J2ZtIqYOYpqIJRya8nJXQqkWJzJTCKgSMND3xBngA84ER8yKCT9A>
    <xmx:V-J2ZryD6ZN3TBWdPaK-sXUnmDcVlGoOTv-CpvaSW1ZYr8H6o6IyPw>
    <xmx:V-J2ZpKQtbK3bzCk6u5LZLVpM-RDCouGZMkBNFTUNqiiDBUCOXyENA>
    <xmx:V-J2ZkUAI8hzpodKfBVUdcn89VYDFkMuPnFKrvtPETVR53tYV0NimfJk>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat,
 22 Jun 2024 10:40:22 -0400 (EDT)
Message-ID: <fd6dbcfb-519a-44ee-b06d-2b9aa97a62a8@aklaver.com>
Date: Sat, 22 Jun 2024 07:40:21 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: AI for query-planning?
To: Andreas Joseph Krogh <andreas@visena.com>, pgsql-general@postgresql.org
References: <VisenaEmail.38.c31ee0594849fa9d.1903fc67a71@origo-test01.app.internal.visena.net>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <VisenaEmail.38.c31ee0594849fa9d.1903fc67a71@origo-test01.app.internal.visena.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/fd6dbcfb-519a-44ee-b06d-2b9aa97a62a8%40aklaver.com>
Precedence: bulk

On 6/22/24 04:50, Andreas Joseph Krogh wrote:
> Hi, are there any plans for using some kind of AI for query-planning?
> 
> Can someone with more knowledge about this than I have please explain 
> why it might, or not, be a good idea, and what the challenges are?

1) Require large amount of resources.

2) Produce high rate of incorrect answers.


> 
> Thanks.
> 
> --
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas@visena.com <mailto:andreas@visena.com>
> www.visena.com <https://www.visena.com>
> <https://www.visena.com>

-- 
Adrian Klaver
adrian.klaver@aklaver.com