Message-ID: <9dd373f9-eb61-4ddc-aa06-99e4ff13a19d@dalibo.com>
Date: Thu, 25 Sep 2025 12:43:18 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
From: =?UTF-8?Q?Fr=C3=A9d=C3=A9ric_Yhuel?= <frederic.yhuel@dalibo.com>
Subject: Re: Indexes on expressions with multiple columns and operators
To: Andrei Lepikhov <lepihov@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>,
 Jehan-Guillaume de Rorthais <jgdr@dalibo.com>,
 Christophe Courtois <christophe.courtois@dalibo.com>,
 Laurenz Albe <laurenz.albe@cybertec.at>
References: <a8b99dce-1bfb-4d97-af73-54a32b85c916@dalibo.com>
 <1507576.1758120083@sss.pgh.pa.us>
 <62133334-b844-4d0b-b248-1a8446757e5f@dalibo.com>
 <1916727.1758209549@sss.pgh.pa.us> <1972974.1758213639@sss.pgh.pa.us>
 <76fbd9ef-1fbb-49f0-bc8b-844462b18d1d@dalibo.com>
 <2432873.1758387110@sss.pgh.pa.us>
 <6ad08c0c-2c03-4b30-b5a7-dc486aa29c52@dalibo.com>
 <b1c2112a-5f1a-4b73-9b21-69d342fad5b0@gmail.com>
 <493a013c-63d1-467a-b9ec-352f77baf37a@dalibo.com>
 <9756a3e9-5dea-4506-a077-72a4d9c302df@gmail.com>
 <c7304dbd-ce2a-40c8-b267-d2c95abfc36e@dalibo.com>
 <bfe29eff-bc5a-473d-8473-c188c83e27b8@gmail.com>
 <d701cab9-c7c9-44f7-ac10-d17ed78bedbb@dalibo.com>
Content-Language: fr, en-US
Autocrypt: addr=frederic.yhuel@dalibo.com; keydata=
 xjMEXn3bgxYJKwYBBAHaRw8BAQdA6tX5FT/n5ztMWIoBdl6k5avvu65fv6ryfVzIx/aH3V3N
 JEYuIFlodWVsIDxmcmVkZXJpYy55aHVlbEBkYWxpYm8uY29tPsKWBBMWCAA+FiEEi7OTyf6H
 ePS+C6n11XGWhN8zGNUFAmZDVJ8CGwMFCQtfi90FCwkIBwIGFQoJCAsCBBYCAwECHgECF4AA
 CgkQ1XGWhN8zGNV65gEA6o+UrebFjn2CIAOYwP3CiiJugiM5TMH9yJyehQua5ZoA/2ChxiVn
 8OUaAw/ErxJmQi1mSN0tNZBL/KhkUPBDUDQNzjgEXn3bgxIKKwYBBAGXVQEFAQEHQCuh5cLQ
 AtEBXHa2Fmtp0kduBu7msM7qO/gaEcdjFUdiAwEIB8J+BBgWCAAmAhsMFiEEi7OTyf6HePS+
 C6n11XGWhN8zGNUFAmZDVJ8FCQtfi90ACgkQ1XGWhN8zGNWOOAEArSqePBqfd4Kx4ulACaWO
 6fM+XSDfUlBAQXx9rU6DR4MBALwozl9g91tRysim6lKxggvBfp/PvbpTZNrxYLWB2fYP
In-Reply-To: <d701cab9-c7c9-44f7-ac10-d17ed78bedbb@dalibo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/9dd373f9-eb61-4ddc-aa06-99e4ff13a19d%40dalibo.com>
Precedence: bulk


On 9/23/25 15:31, Fr=C3=A9d=C3=A9ric Yhuel wrote:
> To get back to the topic of partitioned statistics, do you know if SQL=20
> Server is smart enough to handle this case [1] that we discussed last=20
> year? (with filtered statistics)
>=20
> [1] https://www.postgresql.org/message-id/flat/b860c71a-7cab-4d88-=20
> ad87-8c1f2eea9ae8%40dalibo.com
>=20

Sorry, it doesn't make any sense.

First of all, it's not possible to do something like this with SQL Sever:

CREATE STATISTICS OrdersStats
      ON orders (id, product_id)
WHERE product_id IN (SELECT id FROM products WHERE name =3D 'babar');

this is because you need to use simple scalar expressions in the filter=20
clause.

An even if it were possible... it would be completely useless in this=20
case. Sorry for the noise.