TopicMailing ListsActivityParticipants
RI fast path gets cross-type foreign keys wrong
hackers
9 replies
about 1 hour ago
Amit LangotePeter GeogheganMihail Nikalayeu
19 commits
read_stream: Only increase read-ahead distance when waiting for IO
master19beta1REL_19_STABLE19beta1
aio: io_uring: Trigger async processing for large IOs
master19beta1REL_19_STABLE19beta1
read stream: Split decision about look ahead for AIO and combining
master19beta1REL_19_STABLE19beta1
heapam: Keep buffer pins across index scan resets.
master19beta1REL_19_STABLE19beta1
heapam: Track heap block in IndexFetchHeapData.
master19beta1REL_19_STABLE19beta1
+14 more
PG20-2Needs review
Patch#4351
TagsPerformance
CINeeds rebase
ReviewersJerry Zhang (xingtanzjr)
index prefetching
index prefetching
hackers
495 replies
about 14 hours ago
Peter GeogheganTomas VondraAndres FreundKonstantin KnizhnikAlexandre Felipe+13
Hash index bucket split bug
hackers
5 replies
2 days ago
Peter GeogheganAmit Kapilavignesh C
1 commit
Add ssup_datum_uint32_cmp for comparing OIDs
masterunreleased
btoidsortsupport issue
btoidsortsupport issue
hackers
7 replies
2 days ago
David RowleyPeter GeogheganTom LaneJohn Naylor
1 commit
Fix unlikely incremental tuple deform bug with missing attrs
masterunreleasedREL_19_STABLE19beta3
Whole row var issue
Whole row var issue
hackers
4 replies
6 days ago
Peter GeogheganDavid Rowley
GiST multirange index scans can fail to return rows
hackers
6 replies
Aug 02, 20:11
Peter GeogheganAndrey BorodinAlexander KorotkovKirill Reshke
2 commits
Fix autovacuum-induced flakiness in backwards scan test.
masterunreleased
Add test coverage for nbtree backwards scans.
masterunreleased
nbtree backwards scan test coverage
nbtree backwards scan test coverage
hackers
5 replies
Jul 29, 14:47
Peter GeogheganAndrey BorodinAlexander Lakhin
Snapshot export on a standby corrupts hint bits on subxact overflow
hackers
2 replies
Jul 29, 09:36
Bertrand DrouvotPeter Geoghegan
Simplifying how nbtree represents array scan keys
hackers
0 replies
Jul 26, 19:14
Peter Geoghegan
1 commit
Run nbtree test module tests under autoconf builds
masterunreleasedREL_19_STABLE19beta3
nbtree test module Makefile oversight
nbtree test module Makefile oversight
hackers
2 replies
Jul 20, 02:16
Peter GeogheganMichael Paquier
1 commit
Add _bt_set_startikey row compare test coverage.
masterunreleasedREL_19_STABLE19beta3
nbtree _bt_set_startikey row compare test coverage
nbtree _bt_set_startikey row compare test coverage
hackers
0 replies
Jul 20, 00:33
Peter Geoghegan
5 commits
Add tests for nbtree empty index predicate locking.
masterunreleased
Fix another empty nbtree index SSI race.
masterunreleasedREL_19_STABLE19beta3REL_18_STABLE18.6REL_17_STABLE17.11REL_16_STABLE16.15REL_15_STABLE15.19REL_14_STABLE14.24
Fix race in SSI interaction with empty btrees.
master17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16beta3REL_15_STABLE15.4REL_14_STABLE14.9REL_13_STABLE13.12+2 more
Fix race in SSI interaction with gin fast path.
master17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16beta3REL_15_STABLE15.4REL_14_STABLE14.9REL_13_STABLE13.12+2 more
Fix race in SSI interaction with bitmap heap scan.
master17beta1REL_19_STABLE17beta1REL_18_STABLE17beta1REL_17_STABLE17beta1REL_16_STABLE16beta3REL_15_STABLE15.4REL_14_STABLE14.9REL_13_STABLE13.12+2 more
BUG #17949: Adding an index introduces serialisation anomalies.
BUG #17949: Adding an index introduces serialisation anomalies.
bugs
27 replies
Jul 19, 19:53
Thomas MunroDmitry DolgovArtem AnisimovPeter GeogheganPG Bug reporting form+1
1 commit
Fix GiST index-only scan column alignment issue.
masterunreleasedREL_19_STABLE19beta3REL_18_STABLE18.6REL_17_STABLE17.11REL_16_STABLE16.15REL_15_STABLE15.19REL_14_STABLE14.24
Bug: GiST index-only scans can use tuple descriptor with incorrect alignment when deforming
Bug: GiST index-only scans can use tuple descriptor with incorrect alignment when deforming
hackers
3 replies
Jul 17, 19:56
Peter GeogheganTomas Vondra
1 commit
Use fake LSNs consistently in hash index AM.
masterunreleasedREL_19_STABLE19beta3
Hash index AM fake LSN oversight
Hash index AM fake LSN oversight
hackers
2 replies
Jul 16, 22:11
Peter GeogheganEwan Young
TID recycling race during nbtree index-only scans that run on a standby
hackers
2 replies
Jul 07, 18:32
Peter GeogheganMatthias van de Meent
1 commit
Do not lock in BufferGetLSNAtomic() on archs with 8 byte atomic reads
master19beta1REL_19_STABLE19beta1
PG20-1Committed
Patch#6334
TagsPerformance
CINeeds rebase
CommitterTomas Vondra (fuzzycz)
Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations
Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations
hackers
11 replies
Mar 11, 13:37
Andres FreundAndreas KarlssonTomas VondraPeter Geoghegan
1 commit
Standardize cleanup lock terminology.
master15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1
PG20-1Withdrawn
Patch#5542
TagsBugfix
CINeeds rebase
Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM?
Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM?
hackers
27 replies
Dec 24, 2025
Matthias van de MeentPeter GeogheganMichail NikolaevAndrey BorodinHeikki Linnakangas+1
2 commits
Clarify why _bt_killitems sorts its items array.
master19beta1REL_19_STABLE19beta1
Return TIDs in desc order during backwards scans.
master19beta1REL_19_STABLE19beta1
PG19-4Committed
Patch#5824
TagsPerformance
CICI score: 10/10
ReviewersMircea Cadariu (mcadariu)
CommitterPeter Geoghegan (pgeoghegan)
Returning nbtree posting list TIDs in DESC order during backwards scans
Returning nbtree posting list TIDs in DESC order during backwards scans
hackers
16 replies
Dec 11, 2025
Peter GeogheganMircea CadariuChao LiVictor YegorovAndy Fan
2 commits
Avoid pointer chasing in _bt_readpage inner loop.
master19beta1REL_19_STABLE19beta1
Relocate _bt_readpage and related functions.
master19beta1REL_19_STABLE19beta1
PG19-4Committed
Patch#6286
TagsRefactoring Only
CICI score: 10/10
CommitterPeter Geoghegan (pgeoghegan)
Moving _bt_readpage and _bt_checkkeys into a new .c file
Moving _bt_readpage and _bt_checkkeys into a new .c file
hackers
7 replies
Dec 08, 2025
Peter GeogheganVictor YegorovHeikki Linnakangas
hackers
1 reply
Dec 03, 2025
Peter Geoghegan
1 commit
Reset btpo_cycleid in nbtree VACUUM's REDO routine.
master18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID
nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID
hackers
7 replies
Nov 19, 2025
Peter GeogheganAndrey BorodinMichael Paquier
1 commit
Document nbtree row comparison design.
master19beta1REL_19_STABLE19beta1REL_18_STABLE18.1
Fully documenting the design of nbtree row comparison scan keys
Fully documenting the design of nbtree row comparison scan keys
hackers
5 replies
Nov 02, 2025
Peter GeogheganChao LiVictor Yegorov
Postgres: Queries are too slow after upgrading to PG17 from PG15
bugs
53 replies
Oct 07, 2025
Peter GeogheganSajith Prabhakar ShettyTom LaneTodd CookMerlin Moncure+2
2 commits
Add test for HeapBitmapScan's broken skip_fetch optimization
master18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
Remove HeapBitmapScan's skip_fetch optimization
master18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1REL_17_STABLE17.5REL_16_STABLE16.9REL_15_STABLE15.13REL_14_STABLE14.18REL_13_STABLE13.21
2025-03Committed
Patch#5448
CICI score: 10/10
CommitterAndres Freund (andresfreund)
Incorrect result of bitmap heap scan.
Incorrect result of bitmap heap scan.
hackers
45 replies
Sep 16, 2025
Andres FreundPeter GeogheganMatthias van de MeentTom LaneCore Studios Inc.+2
20 commits
nbtree: Always set skipScan flag on rescan.
master19beta1REL_19_STABLE19beta1REL_18_STABLE18.0
Revert "nbtree: Remove useless row compare arg."
master18beta2REL_19_STABLE18beta2REL_18_STABLE18beta2
Prevent premature nbtree array advancement.
master18beta2REL_19_STABLE18beta2REL_18_STABLE18beta2
nbtree: tighten up array recheck rules.
master18beta2REL_19_STABLE18beta2REL_18_STABLE18beta2
Avoid treating nonrequired nbtree keys as required.
master18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
+15 more
2025-03Committed
Patch#5081
CICI score: 10/10
ReviewersAleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (a.rybakina)
CommitterPeter Geoghegan (pgeoghegan)
Adding skip scan (including MDAM style range skip scan) to nbtree
Adding skip scan (including MDAM style range skip scan) to nbtree
hackers
152 replies
Sep 15, 2025
Peter GeogheganTomas VondraMatthias van de MeentAlena RybakinaMasahiro Ikeda+7
Loading more results...