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 ) id 1tunDb-00BbKI-S8 for pgsql-general@arkaria.postgresql.org; Wed, 19 Mar 2025 06:48:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tunDZ-00FAt4-To for pgsql-general@arkaria.postgresql.org; Wed, 19 Mar 2025 06:47:57 +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 ) id 1tunDZ-00FAsw-EB for pgsql-general@lists.postgresql.org; Wed, 19 Mar 2025 06:47:57 +0000 Received: from mx0c-001a4c01.pphosted.com ([67.231.158.153]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tunDW-003eJy-04 for pgsql-general@postgresql.org; Wed, 19 Mar 2025 06:47:55 +0000 Received: from pps.filterd (m0075701.ppops.net [127.0.0.1]) by mx0c-001a4c01.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 52J41Sad028738 for ; Wed, 19 Mar 2025 02:47:52 -0400 Received: from eur05-am6-obe.outbound.protection.outlook.com (mail-am6eur05lp2109.outbound.protection.outlook.com [104.47.18.109]) by mx0c-001a4c01.pphosted.com (PPS) with ESMTPS id 45d2tbmx35-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Wed, 19 Mar 2025 02:47:52 -0400 (EDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=pNZq46vdOpiSRr2YvgJfdSSDho9iwrpqONX13RimeY1k6wImjC1WDC9ZS+0+bARNEUbMfYjeIl/m1vLdL0jSKRoa4Sa4t2Z7EFvg76kPUzd4pOp/stcutRLigFPtEG4ncGD9iag6zoM/g7KprWG/kmJWI+4LhziNjaSQAQtT8E6dsaDYXW/59fl5aRyFpWxynM+KbfbqtCyYSdmZ+eFgibMN+gfai2m5FI8PTKCg2YI71G6txtLRyudP3pgkKPYDLuz5IRRDTdSihvPYR87MI020Ja3twnXUqmW9HZm9CL+ChHOO3K9H+kUcsAv/ixEcIDKIdaJlWTC08ccZhSJ3jg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=jJ+UbsU2RzwcCiOudD0ZBwrIqUoZuoVOFkyFdbG5iVg=; b=aTIG3KNjbhbu9NA8/HzilEXFSLcvgIf94LJb2xnDvef7uqGSHF7cYvtUF7N3tPmGH9lbxoxsZpCBjU6bWes8VdcP6+zLnKsgw5ETQwVnWgo3tcbRr2YbgevdUcFAe47VlDuWKM44HAHIGwobsinpPrVGqVK8YGCLbYA6jnj248kdwfpFBCXGDFBv/POjA2ZEUHy1lvDvmGfFpEJW+ZjsbaWmA1OqWNWnCCFkf3kfStFEKFCq4sdRrmmZbiTVr8p9HM3YeKFQKJdlDvIhiYAPg9JCRBVU//p9ut5JzWXzCnh1tYQtfOZDy+M28Qx+4eFxEAnTJzfygHbbXNvXhLRnSQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=4js.com; dmarc=pass action=none header.from=4js.com; dkim=pass header.d=4js.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ourvolaris.onmicrosoft.com; s=selector2-ourvolaris-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=jJ+UbsU2RzwcCiOudD0ZBwrIqUoZuoVOFkyFdbG5iVg=; b=pCbNWkK97pFy81T5aVx81pU34PAA6nxS6/pBVz9+sxgJguASOaTVBQheQETfi7SFy/DKrNMh8yHpYZtBYWBb9MFTMpz+lzMxzZ53cg7I0ifgyZVfDLkRXRty9kWL1K3Hn2pOpvEUU4HXGT/0qs2fZT1OmjxMTcMv3NeSWyZXASo= Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:1c9::19) by AM7P191MB1025.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:170::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8534.33; Wed, 19 Mar 2025 06:47:49 +0000 Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::9a60:21a1:9aa2:cdb0]) by DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::9a60:21a1:9aa2:cdb0%4]) with mapi id 15.20.8534.031; Wed, 19 Mar 2025 06:47:49 +0000 From: Sebastien Flaesch To: "pgsql-general@postgresql.org" Subject: pgvector as standard PostgreSQL feature? Thread-Topic: pgvector as standard PostgreSQL feature? Thread-Index: AQHbmJn2JKCBHmEf4UyFr5e5BEFOaw== Date: Wed, 19 Mar 2025 06:47:49 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DBAP191MB1289:EE_|AM7P191MB1025:EE_ x-ms-office365-filtering-correlation-id: b532bd12-7557-4540-6f88-08dd66b1f709 x-volarisppoutbound: true x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|376014|1800799024|38070700018|8096899003; x-microsoft-antispam-message-info: =?iso-8859-1?Q?/44Q4ryQAns2zDXQcV7MAjFooDfAlDVXLAgtAHaCrtI7gtj0A0JJ6KwwuV?= =?iso-8859-1?Q?twWYPJv7BWwVtW+s3WAJlH271XJLlgmR7Xagmw+wx9Jkem7Np6OGIU6Lqn?= =?iso-8859-1?Q?b7bAgYcmJqTsBG0Eax834JNXS6JbU5UKLWt7C4de89J5p4cxn106tP6W5L?= =?iso-8859-1?Q?I7OtlNrnE8d/JkKikhkO6LWv6bKiMkb8X0AkpUskFe+qDBUULZmk/Jlj31?= =?iso-8859-1?Q?QrtjHRHIaYlO5Da5BK11ZSrHJpqOSPRxJM5U0WMMN0BmgLwFBT5P3fzuU2?= =?iso-8859-1?Q?q5p+sU+jFaA7R4pbWaLEFtOVBfwiWJhYpvAn2pM79v6pC7oAeYH+JEpJw5?= =?iso-8859-1?Q?IV7sKmi5HsKYdATJ4/IHcjphO/2H0s/7V8QB3Ui1vsgmql1bdeZeQlw5gF?= =?iso-8859-1?Q?Vv/zkTaa2DkLZkdl2ltz6PSsKOoSXEExEiQJVdylmTN1k+PxozrW/b8klU?= =?iso-8859-1?Q?JG3nj3huf2NkAGsolVar70y+fXZWxPxBuM20IKalqlCKM7CxP2Knb3shp4?= =?iso-8859-1?Q?Rs0CBtJbMZcfqFYsyEkySgj9L+5jTrErWayN5P9TZz/cFelHw+nm6bM4B2?= =?iso-8859-1?Q?aDKs3d6zsf2P7BDis81O0Xu1LIQJYFVpUiIrF9xgr65XgHasUQwdPF/f56?= =?iso-8859-1?Q?W9N5wSFxqSkWAvfWIdHpj4oRWWxW/Pn2032M8pCQmv8y2KcYbzshOK4GSS?= =?iso-8859-1?Q?D0dXOtQjdr3aVyR9weBcqzxbjLUuvWFftCtZRtX03wczWZZNiRJik8Nd4y?= =?iso-8859-1?Q?B0ZVEXNutK8ihtcaUO00Cq3hENzyQqZK107vYQhrYIluyCP4VY7UL7zM+K?= =?iso-8859-1?Q?4KAESHApyKwvb5//d1xVnbIqAK4utpydUcGLsmNr1jsSU00A0UmKrog3W3?= =?iso-8859-1?Q?NhU6H0IhO9nirk0xXLV7Cksy8/PXSgWchi3yLrJT0bET0MopG5YwSUzSYe?= =?iso-8859-1?Q?bVkF4PIZsERb3FJKvBY2DMkN98Q4lPy/w+V5WD+1n4cDjXQqbBoTagk+0O?= =?iso-8859-1?Q?Ei6NZ14Pk0bKF+Honi7sDZZWbsbY/VqYwwiM20JGvVW7PnbH/TWER7bB4P?= =?iso-8859-1?Q?mUi933/J2mniL66m7cw+nCkl13ACd0BD2oXzqG8VF4D5QDFGQMmSfJcpiE?= =?iso-8859-1?Q?TrJj43IryLqZBf+XrD2KW1dlRhb1DrW1aHcC+uilP92MdrGsYkWFSE4svg?= =?iso-8859-1?Q?oyrDXATbGwJfaY1FkEKcfDldnz34XmJxopOg4difsYOp7a7bLK8nQ+JBmm?= =?iso-8859-1?Q?t09HHQTfL4fpgNKMubKJxBk0SNgAECW9YBz4/yWmrTa4X2eVCH5Hd6w09r?= =?iso-8859-1?Q?CSjRAjHzpsZInXwW+xUhWZ8YNX9zhA24Fd9UxezMvArNU0/G5WFAmC71l0?= =?iso-8859-1?Q?hS/e74RYS7nhONk4pDQtynCPCFegbGWXLHjZttlD64ePFbLajVxSu8qnSM?= =?iso-8859-1?Q?HuJ3AXfO7cyuHs0C1cEG0/c+egEm7ePgOmLOKhsSVOBoiAr8v23EHWrlm0?= =?iso-8859-1?Q?Nw+8wlbdTzWq1vjwAdNUya?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DBAP191MB1289.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(376014)(1800799024)(38070700018)(8096899003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?udI+I5pY0pvXlo9iRRvC+oDBOd69PZMGBVMgQKjyLo2T3okNqmc+0QfrjQ?= =?iso-8859-1?Q?vTR+PzHV3DI8kMVzkNjDWsMrbVK136lduCZ0zXx4QF3IFJk0aK3/QtqB+w?= =?iso-8859-1?Q?dvBTUGoId4P+7gEp/dxnlQOocirceZWk67e8SpvkQW/HcW8k89fpK8lgGp?= =?iso-8859-1?Q?VP4ZlRooTnoMNVWKASMu6e0GPI489UySttGtO7Z/qJxUlTvo/64HOM5ZtA?= =?iso-8859-1?Q?ibhVQWysiQrQWWtYX/XoiHtaSAOHO9G52n21bNRKzq7xAwMVnOsJOd8mmd?= =?iso-8859-1?Q?+5+/AI0bfYaZyM77Ht/DRiIbqt5YbPnbFQHKUvy8SY6+1vpBHpCa/Q2e9N?= =?iso-8859-1?Q?A1Db2aaO4d2prn4eYuBdAoGhVtvcQ9cnY++k5Xi8egUSvBaJPeJXHFij18?= =?iso-8859-1?Q?erH6motDtmaXJuAJ2A5wbXLSyd1CB2LIrd/j4GmykBuWZxcSWsA1+vL0v9?= =?iso-8859-1?Q?kwTW3fRtPVK22EYfiaqOUVIa0SgtkmQNP/vxMgC5kNzqZqd7sTana8TR0X?= =?iso-8859-1?Q?tB0JewrKq0sKf+l5cgwSdvBRq49NEQIzM5EYcVIIJLSEXg9WeB7ej6zx6U?= =?iso-8859-1?Q?6f9DTXkaq1Y6VWMim4Ilryn9lw9K4Y/CG1VXgSBVi2l3QF0N04555bhEi5?= =?iso-8859-1?Q?KkMlHQlrsAp7pTR/RbRdUGY4Dwk01MfkvELE+UOmRS0QdwGUNgus/XkmCv?= =?iso-8859-1?Q?4iESJ0byCD9U1FZiy9b4SsymUSodHwm+V7v1NNArlwfihZ4Ja3hnfDYTE1?= =?iso-8859-1?Q?+mptvp+7XCGELV6ZeZsjb0j2S33UqzFNKuWDVpYvIETs8+zaUiAj03s0pQ?= =?iso-8859-1?Q?FYiDmU25IwnI0CM6a3h0mVucNuK6GmugfwdAecU5YEuLwRW+29sS3rHJ1V?= =?iso-8859-1?Q?F3dcQmsm95870Kz0BTZJxfLfD3QN1aehhlHew64xNFG0AQrAFkAQSgkThb?= =?iso-8859-1?Q?4Nqt7gKFGd/1WY7LbD9zjpXUiLVvqhnnTm+UmI/T8xxRWr66/RIzZNp12M?= =?iso-8859-1?Q?oun9lkw/Nt/A/gAV8VzTU/5HT+sI1NrPphBkrEJI0IooxRl8moAdvkXBn9?= =?iso-8859-1?Q?/6kLCkrcC0IKfgU8UJljIx7MqFibOSpfhwkiDtmQz3RevxPwcMc4M0kJYU?= =?iso-8859-1?Q?VlLM3WfQhcSqcPmotA4hD9SKBcDKfJ1IDj9b3mYxIxC9RM13ToY5Ql6QK/?= =?iso-8859-1?Q?S7Mic3w0u8m7C7UEuuOsF6MGM5KXaeJzwuRzbql+kpDSt/kKlA6aCMjNQq?= =?iso-8859-1?Q?MO0RaprLKBxM9gg4YYttuBs5DJ3CtRjRiJU4+1Jjj0cDo3UtQMmXY1Vfpl?= =?iso-8859-1?Q?hLJpIX9Cso62tE6XoI2TJW4+of6lAErH5blQFyAm51C6bFouJYWH7UboAN?= =?iso-8859-1?Q?ctrKyk4kGqDci89+8g7VhfMeos2CpaO+nFupb3a90tLG63VqP3YsrcUU3s?= =?iso-8859-1?Q?XfLtYYGFjGT238/sz85EokA536+1gV2E4zoZJzrOML7GznYkqqQwrjDQOd?= =?iso-8859-1?Q?R9Isee5Ku9cD2SnK5fXMLMV5kO3zVINJy0xPpLtnn3GH+ejOWIjK9a4yyS?= =?iso-8859-1?Q?Zyvb019ZbS1G626bgPH7dF9pBatCKSPTCpEIAHJHuZUgHcuDWAHbxEKinl?= =?iso-8859-1?Q?2Siw/j1QVnTsxN//zyQWYx6Bc/NNBR+/pe?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB12893E8288EBE762637FA86CB0D92DBAP191MB1289EURP_" MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: hznUXrASz/x5InUEKlaZgIVAehTiypE5JjGtpJwUtM2EO16k8bi5OuL7B37YWs6uk+3FfwPpNHxc/QsyF75fscYN5Y2wkMJuPgZi6hFlzJtvSkYPCDFbmo3rgn+eBBk12wPBLZM+THnqma/GhumjyY75biG0TtwxJ+yo582PTvtgVP0pHd9vaFLBaEJZvzvbpZsoPRRcwziTFygrXQ9jar0HC1FhG887LalPe+QEca+xNrw81Erau7CELo5JrfaLZ7QvkHzFUoCXCAeN1LkJPu08jprkFXjn9Xo8UiPWUSfxXVh5UYNNwoeLKh2aZ4RVlqR8LBeZtvC84A7oBcN59RpFrAbGoYLdl0AylWvMzORI74iU5hVWg05efheOGFL3TpcrV1KnFcxs6XCnt0GMBxGEH9s8TiGnkm0QRYJFpSXFlh4abLgr2Ti0MVWnEeR3CgN/YtMn3hAGKbbeOoYE1dkJrZiADhljx8t5xZCcsIqYAo8w20G7tFVfKCazHfKubj75EQlc/nLJOHcJvmNepJd6JrIXOaMixPP9IA7d+WADpCX1J/OsHxE4xy8E8IJUMEkquhMGOpdIugfz1SLdJPy4yqZBJeWVHpKkBkh+DAaWBokL/u63oFPEdp6wezLgzNoibyXFDg7bYm/g8YXK3Q== X-OriginatorOrg: 4js.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DBAP191MB1289.EURP191.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: b532bd12-7557-4540-6f88-08dd66b1f709 X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Mar 2025 06:47:49.6112 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75c696ec-5bfb-4892-9a0c-9187a9061cd6 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 9AGj6tuJU1nsoCu5BoYoek9mU4UL0MkDuRkOyC67EVYJWL7XdmxvkXWU4zwH8GvAVfYSBNlypKKLQggcDwZe7ge8I6OHopqZ0gzLblN3YBg= X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM7P191MB1025 X-Authority-Analysis: v=2.4 cv=I79lRMgg c=1 sm=1 tr=0 ts=67da6898 cx=c_pps a=py/jgptSVLV3EdsN+h8ZCA==:117 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=Vs1iUdzkB0EA:10 a=H5OGdu5hBBwA:10 a=udrfY5dcTTYA:10 a=CtYAhoE57Dk7g2FawAwA:9 a=wPNLvfGTeEIA:10 a=mtAMvpSgeuiwGrAz27kA:9 a=yjDTKVBSPTO3Vlfq:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 X-Proofpoint-GUID: 3gQBEnwGgPalE1a_scr0JP5qBAR03LVG X-Proofpoint-ORIG-GUID: 3gQBEnwGgPalE1a_scr0JP5qBAR03LVG X-ProofpointHeader: Yes X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 bulkscore=0 lowpriorityscore=0 spamscore=0 clxscore=1015 adultscore=0 phishscore=0 malwarescore=0 mlxscore=0 suspectscore=0 mlxlogscore=341 impostorscore=0 priorityscore=1501 classifier=spam authscore=0 authtc=n/a authcc= route=outbound adjust=0 reason=mlx scancount=1 engine=8.21.0-2502280000 definitions=main-2503190045 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DBAP191MB12893E8288EBE762637FA86CB0D92DBAP191MB1289EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am looking at pgvector, pgvectorscale, pgai extensions. Other DB engines support built-in vector types. Is there a plan to get pgvector's types (vector, halfvec, sparsevec, bit) i= mplemented as native built-in data types like json/jsonb ? Side note: I have some doubts about these type names, especially "bit" ... = why not "bitvec"? Seb --_000_DBAP191MB12893E8288EBE762637FA86CB0D92DBAP191MB1289EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,

I am looking at pgvector, pgvectorscale, pgai  extensions.

Other DB engines support built-in vector types.

Is there a plan to get pgvector's types (vector, halfvec, sparsevec, bit) i= mplemented as native built-in data types like json/jsonb ?

Side note: I have some doubts about these type names, especially "bit&= quot; ... why not "bitvec"?

Seb
--_000_DBAP191MB12893E8288EBE762637FA86CB0D92DBAP191MB1289EURP_--