pgsql: Allow indexscans on partial hash indexes with implied quals.

2025-11-27 Thread Tom Lane
Allow indexscans on partial hash indexes with implied quals. Normally, if a WHERE clause is implied by the predicate of a partial index, we drop that clause from the set of quals used with the index, since it's redundant to test it if we're scanning that index. However, if it's a hash index (or an

pgsql: Allow indexscans on partial hash indexes with implied quals.

2025-11-27 Thread Tom Lane
Allow indexscans on partial hash indexes with implied quals. Normally, if a WHERE clause is implied by the predicate of a partial index, we drop that clause from the set of quals used with the index, since it's redundant to test it if we're scanning that index. However, if it's a hash index (or an

pgsql: Allow indexscans on partial hash indexes with implied quals.

2025-11-27 Thread Tom Lane
Allow indexscans on partial hash indexes with implied quals. Normally, if a WHERE clause is implied by the predicate of a partial index, we drop that clause from the set of quals used with the index, since it's redundant to test it if we're scanning that index. However, if it's a hash index (or an

pgsql: Allow indexscans on partial hash indexes with implied quals.

2025-11-27 Thread Tom Lane
Allow indexscans on partial hash indexes with implied quals. Normally, if a WHERE clause is implied by the predicate of a partial index, we drop that clause from the set of quals used with the index, since it's redundant to test it if we're scanning that index. However, if it's a hash index (or an

pgsql: Allow indexscans on partial hash indexes with implied quals.

2025-11-27 Thread Tom Lane
Allow indexscans on partial hash indexes with implied quals. Normally, if a WHERE clause is implied by the predicate of a partial index, we drop that clause from the set of quals used with the index, since it's redundant to test it if we're scanning that index. However, if it's a hash index (or an

pgsql: Allow indexscans on partial hash indexes with implied quals.

2025-11-27 Thread Tom Lane
Allow indexscans on partial hash indexes with implied quals. Normally, if a WHERE clause is implied by the predicate of a partial index, we drop that clause from the set of quals used with the index, since it's redundant to test it if we're scanning that index. However, if it's a hash index (or an