Skip to content

Releases: orioledb/postgres

Version 17_4

06 Nov 13:50
Compare
Choose a tag to compare
Stabilize jsonb_path_query test case.

An operation like '12:34:56'::time_tz takes the UTC offset from
the prevailing time zone, which means that the results change
across DST transitions.  One of the test cases added in ed055d249
failed to consider this.

Per report from Bernhard Wiedemann.  Back-patch to v17, as the
test case was.

Discussion: https://postgr.es/m/ba8e1bc0-8a99-45b7-8397-3f2e94415e03@suse.de

Version 16_32

06 Nov 13:39
Compare
Choose a tag to compare
Teach bitmap path generation about transforming OR-clauses to SAOP's

When optimizer generates bitmap paths, it considers breaking OR-clause
arguments one-by-one.  But now, a group of similar OR-clauses can be
transformed into SAOP during index matching.  So, bitmap paths should
keep up.

This commit teaches bitmap paths generation machinery to group similar
OR-clauses into dedicated RestrictInfos.  Those RestrictInfos are considered
both to match index as a whole (as SAOP), or to match as a set of individual
OR-clause argument one-by-one (the old way).

Therefore, bitmap path generation will takes advantage of OR-clauses to SAOP's
transformation.  The old way of handling them is also considered.  So, there
shouldn't be planning regression.

Discussion: https://postgr.es/m/567ED6CA.2040504%40sigaev.ru
Reviewed-by: Alexander Korotkov <aekorotkov@gmail.com>

Version 17_3

22 Oct 08:44
Compare
Choose a tag to compare
patches17_3

Fix active snapshot checks

Version 17_2

21 Oct 11:26
Compare
Choose a tag to compare
Revert pre 5bf748b86bc67 SAOP behavior in PG17

Commit 5bf748b86bc67 allows generation of unsafe SAOP path keys
on a multicolumn index that were disabled previously by 807a40c5.

Version 17_1

18 Oct 10:32
Compare
Choose a tag to compare
patches17_1

Fix warning in pg_rewind

Version 16_31

17 Oct 12:57
Compare
Choose a tag to compare
Make index insert compatible with outside callers

We split aminsert method to aminsert and aminsertextended.

aminsert is a method for indexes implemented in other extensions, it
accepts ItemPointer tupleid.

aminsertextended is for internal Postgres indexes and Orioledb, it
accepts Datum tupleid. They are not supposed to call aminsert method, so
that it is set NULL for them. We can not rely that extensions are aware
of aminsertextended, so index_insert() calls aminsert if it's not NULL
preferentially.

Signature of index_insert() is reverted so that it could be called by other
extensions. Datum tupleid is confined inside index_insert method.

patches16_30

16 Oct 10:11
Compare
Choose a tag to compare
Restore GetIndexAmRoutine signature for compatibility with other callers

Use GetIndexAmRoutineExtended instead for all Orioledb extensibility.