chore: Add support for configurable error ignores in `stressgres`. by stuhood · Pull Request #4021 · paradedb/paradedb

stuhood · 2026-01-28T22:29:28Z

What

Add support for ignoring configurable error strings.

Why

For use in enterprise.

paradedb-bot

pg_search single-server.toml Performance - TPS

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Aggregate Custom Scan - Primary - tps`	`130.4963290919134` median tps	`121.54103412089093` median tps	`0.93`
`Delete values - Primary - tps`	`2959.405495380268` median tps	`3018.7863735186793` median tps	`1.02`
`Index Scan - Primary - tps`	`476.481340084042` median tps	`476.9156084903971` median tps	`1.00`
`Insert value - Primary - tps`	`3014.8559735313365` median tps	`3034.048674957665` median tps	`1.01`
`Mixed Fast Field Scan - Primary - tps`	`539.4884748075192` median tps	`499.49776994361434` median tps	`0.93`
`Normal Scan - Primary - tps`	`540.7095252197904` median tps	`539.827418527926` median tps	`1.00`
`Update random values - Primary - tps`	`1883.0699468503797` median tps	`1862.3917703370205` median tps	`0.99`
`Vacuum - Primary - tps`	`40.149111659417116` median tps	`51.592428548794274` median tps	`1.29`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot

⚠️ Performance Alert ⚠️

Possible performance regression was detected for benchmark 'pg_search single-server.toml Performance - TPS'.
Benchmark result of this commit is worse than the previous benchmark result exceeding threshold 1.10.

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Vacuum - Primary - tps`	`40.149111659417116` median tps	`51.592428548794274` median tps	`1.29`

This comment was automatically generated by workflow using github-action-benchmark.

CC: @stuhood

paradedb-bot

pg_search single-server.toml Performance - Other Metrics

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Aggregate Custom Scan - Primary - cpu`	`9.248554` median cpu	`9.213051` median cpu	`1.00`
`Aggregate Custom Scan - Primary - mem`	`52.5625` median mem	`62.15625` median mem	`0.85`
`Delete values - Primary - cpu`	`4.6332045` median cpu	`4.6153846` median cpu	`1.00`
`Delete values - Primary - mem`	`33.40625` median mem	`34.94140625` median mem	`0.96`
`Index Scan - Primary - cpu`	`4.619827` median cpu	`4.6065254` median cpu	`1.00`
`Index Scan - Primary - mem`	`49.11328125` median mem	`60.28515625` median mem	`0.81`
`Insert value - Primary - cpu`	`4.6376815` median cpu	`4.6153846` median cpu	`1.00`
`Insert value - Primary - mem`	`39.5078125` median mem	`48.62109375` median mem	`0.81`
`Mixed Fast Field Scan - Primary - cpu`	`4.6376815` median cpu	`4.619827` median cpu	`1.00`
`Mixed Fast Field Scan - Primary - mem`	`51.66015625` median mem	`61.0234375` median mem	`0.85`
`Monitor Index Size - Primary - block_count`	`669` median block_count	`1806` median block_count	`0.37`
`Monitor Index Size - Primary - segment_count`	`7` median segment_count	`10` median segment_count	`0.70`
`Normal Scan - Primary - cpu`	`4.6376815` median cpu	`4.619827` median cpu	`1.00`
`Normal Scan - Primary - mem`	`51.61328125` median mem	`61.1328125` median mem	`0.84`
`Update random values - Primary - cpu`	`4.64666` median cpu	`4.619827` median cpu	`1.01`
`Update random values - Primary - mem`	`42.26953125` median mem	`50.92578125` median mem	`0.83`
`Vacuum - Primary - cpu`	`0` median cpu	`4.6376815` median cpu	`0`
`Vacuum - Primary - mem`	`41.45703125` median mem	`53.3828125` median mem	`0.78`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot · 2026-01-28T23:02:22Z

…4021) ## What Add support for ignoring configurable error strings. ## Why For use in enterprise. (cherry picked from commit 16d3cb8)

paradedb-bot · 2026-01-28T23:04:19Z

Successfully created backport PR for 0.21.x:

chore: Add support for configurable error ignores in stressgres. #4022

paradedb-bot · 2026-01-28T23:04:24Z

Created backport PR for 0.20.x:

chore: Add support for configurable error ignores in stressgres. #4023 with remaining conflicts!

Please cherry-pick the changes locally and resolve any conflicts.

git fetch origin backport-4021-to-0.20.x
git worktree add --checkout .worktree/backport-4021-to-0.20.x backport-4021-to-0.20.x
cd .worktree/backport-4021-to-0.20.x
git reset --hard HEAD^
git cherry-pick -x 16d3cb89978aeea346fe53c433b1783bc7afb86f
git push --force-with-lease

paradedb-bot

pg_search bulk-updates.toml Performance - TPS

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Bulk Update - Primary - tps`	`7.353139095723757` median tps	`7.216672778016335` median tps	`0.98`
`Count Query - Primary - tps`	`5.465406957213783` median tps	`5.506286042537607` median tps	`1.01`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot

pg_search bulk-updates.toml Performance - Other Metrics

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Bulk Update - Primary - cpu`	`23.210833` median cpu	`23.210833` median cpu	`1`
`Bulk Update - Primary - mem`	`235.3515625` median mem	`235.35546875` median mem	`1.00`
`Count Query - Primary - cpu`	`23.323614` median cpu	`23.30097` median cpu	`1.00`
`Count Query - Primary - mem`	`174.55859375` median mem	`174.390625` median mem	`1.00`
`Monitor Index Size - Primary - block_count`	`33824` median block_count	`33773` median block_count	`1.00`
`Monitor Index Size - Primary - segment_count`	`78` median segment_count	`78` median segment_count	`1`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot · 2026-01-28T23:16:01Z

paradedb-bot

pg_search wide-table.toml Performance - TPS

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Bulk Update - Primary - tps`	`1136.2439962285457` median tps	`1107.7020406649938` median tps	`0.97`
`Single Insert - Primary - tps`	`1297.0025241459139` median tps	`1258.5617474547767` median tps	`0.97`
`Single Update - Primary - tps`	`1854.1866456296934` median tps	`1861.6692865475084` median tps	`1.00`
`Top N - Primary - tps`	`5.429398130376866` median tps	`5.579701130564048` median tps	`1.03`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot

pg_search wide-table.toml Performance - Other Metrics

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Background Merger - Primary - background_merging`	`0` median background_merging	`0` median background_merging	`1`
`Background Merger - Primary - cpu`	`4.655674` median cpu	`4.660194` median cpu	`1.00`
`Background Merger - Primary - mem`	`24.09765625` median mem	`25.11328125` median mem	`0.96`
`Bulk Update - Primary - cpu`	`4.660194` median cpu	`4.660194` median cpu	`1`
`Bulk Update - Primary - mem`	`167.53125` median mem	`167.68359375` median mem	`1.00`
`Monitor Index Size - Primary - block_count`	`51627` median block_count	`53468` median block_count	`0.97`
`Monitor Index Size - Primary - segment_count`	`44` median segment_count	`44` median segment_count	`1`
`Single Insert - Primary - cpu`	`4.660194` median cpu	`4.660194` median cpu	`1`
`Single Insert - Primary - mem`	`124.796875` median mem	`121.99609375` median mem	`1.02`
`Single Update - Primary - cpu`	`4.660194` median cpu	`4.655674` median cpu	`1.00`
`Single Update - Primary - mem`	`167.578125` median mem	`167.1953125` median mem	`1.00`
`Top N - Primary - cpu`	`23.346306` median cpu	`23.346306` median cpu	`1`
`Top N - Primary - mem`	`161.453125` median mem	`161.44140625` median mem	`1.00`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot · 2026-01-28T23:30:10Z

paradedb-bot

pg_search background-merge.toml Performance - TPS

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Custom scan - Primary - tps`	`30.292047529080737` median tps	`30.809768220170817` median tps	`1.02`
`Delete value - Primary - tps`	`239.44385228429445` median tps	`239.64618264905525` median tps	`1.00`
`Insert value - Primary - tps`	`1875.836666655165` median tps	`1891.760591352237` median tps	`1.01`
`Update random values - Primary - tps`	`157.9430090082185` median tps	`161.68083570391315` median tps	`1.02`
`Vacuum - Primary - tps`	`14.5966219788395` median tps	`14.720992120477522` median tps	`1.01`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot

pg_search background-merge.toml Performance - Other Metrics

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Custom scan - Primary - cpu`	`18.550726` median cpu	`18.60465` median cpu	`1.00`
`Custom scan - Primary - mem`	`167.9765625` median mem	`165.21484375` median mem	`1.02`
`Delete value - Primary - cpu`	`4.628737` median cpu	`4.6511626` median cpu	`1.00`
`Delete value - Primary - mem`	`120.6328125` median mem	`119.765625` median mem	`1.01`
`Insert value - Primary - cpu`	`4.624277` median cpu	`4.6421666` median cpu	`1.00`
`Insert value - Primary - mem`	`117.94921875` median mem	`121.04296875` median mem	`0.97`
`Monitor Segment Count - Primary - block_count`	`13390` median block_count	`13789` median block_count	`0.97`
`Monitor Segment Count - Primary - cpu`	`4.619827` median cpu	`4.64666` median cpu	`0.99`
`Monitor Segment Count - Primary - mem`	`91.78125` median mem	`93.45703125` median mem	`0.98`
`Monitor Segment Count - Primary - segment_count`	`24` median segment_count	`23` median segment_count	`1.04`
`Update random values - Primary - cpu`	`9.213051` median cpu	`9.230769` median cpu	`1.00`
`Update random values - Primary - mem`	`156.375` median mem	`158.52734375` median mem	`0.99`
`Vacuum - Primary - cpu`	`13.832853` median cpu	`13.899614` median cpu	`1.00`
`Vacuum - Primary - mem`	`170.2421875` median mem	`170.12890625` median mem	`1.00`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot · 2026-01-28T23:43:28Z

paradedb-bot

pg_search logical-replication.toml Performance - TPS

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Custom Scan - Subscriber - tps`	`511.3466361504351` median tps	`558.3577688179887` median tps	`1.09`
`Index Only Scan - Subscriber - tps`	`580.1335865857524` median tps	`613.9375412061991` median tps	`1.06`
`Parallel Custom Scan - Subscriber - tps`	`86.4014444625193` median tps	`84.41628494251418` median tps	`0.98`
`Top N - Subscriber - tps`	`105.05502708115247` median tps	`106.201523100493` median tps	`1.01`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot

pg_search logical-replication.toml Performance - Other Metrics

Details

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Custom Scan - Subscriber - cpu`	`4.5757866` median cpu	`4.567079` median cpu	`1.00`
`Custom Scan - Subscriber - mem`	`48.91796875` median mem	`49.3515625` median mem	`0.99`
`Delete values - Publisher - cpu`	`4.5584044` median cpu	`4.549763` median cpu	`1.00`
`Delete values - Publisher - mem`	`31.1484375` median mem	`31.1171875` median mem	`1.00`
`Find by ctid - Subscriber - cpu`	`9.142857` median cpu	`9.099526` median cpu	`1.00`
`Find by ctid - Subscriber - mem`	`51.96875` median mem	`51.44140625` median mem	`1.01`
`Index Only Scan - Subscriber - cpu`	`4.5757866` median cpu	`4.567079` median cpu	`1.00`
`Index Only Scan - Subscriber - mem`	`48.625` median mem	`48.61328125` median mem	`1.00`
`Index Size Info - Subscriber - cpu`	`4.5757866` median cpu	`4.567079` median cpu	`1.00`
`Index Size Info - Subscriber - mem`	`32.04296875` median mem	`32.10546875` median mem	`1.00`
`Index Size Info - Subscriber - pages`	`1109` median pages	`1082` median pages	`1.02`
`Index Size Info - Subscriber - relation_size:MB`	`8.6640625` median relation_size:MB	`8.453125` median relation_size:MB	`1.02`
`Index Size Info - Subscriber - segment_count`	`10` median segment_count	`9` median segment_count	`1.11`
`Insert value A - Publisher - cpu`	`4.549763` median cpu	`4.5757866` median cpu	`0.99`
`Insert value A - Publisher - mem`	`28.984375` median mem	`28.96484375` median mem	`1.00`
`Insert value B - Publisher - cpu`	`4.5584044` median cpu	`4.549763` median cpu	`1.00`
`Insert value B - Publisher - mem`	`28.9765625` median mem	`28.75390625` median mem	`1.01`
`Parallel Custom Scan - Subscriber - cpu`	`4.610951` median cpu	`4.597701` median cpu	`1.00`
`Parallel Custom Scan - Subscriber - mem`	`47.046875` median mem	`46.9375` median mem	`1.00`
`SELECT
pid,
pg_wal_lsn_diff(sent_lsn, replay_lsn) AS replication_lag,
application_name::text,
state::text
FROM pg_stat_replication; - Publisher - replication_lag:MB`	`0` median replication_lag:MB	`0` median replication_lag:MB	`1`
`Top N - Subscriber - cpu`	`4.5801525` median cpu	`4.5714283` median cpu	`1.00`
`Top N - Subscriber - mem`	`47.703125` median mem	`47.4296875` median mem	`1.01`
`Update 1..9 - Publisher - cpu`	`4.5757866` median cpu	`4.562738` median cpu	`1.00`
`Update 1..9 - Publisher - mem`	`31.87109375` median mem	`31.7109375` median mem	`1.01`
`Update 10,11 - Publisher - cpu`	`4.562738` median cpu	`4.5411544` median cpu	`1.00`
`Update 10,11 - Publisher - mem`	`31.83203125` median mem	`31.7578125` median mem	`1.00`

This comment was automatically generated by workflow using github-action-benchmark.

paradedb-bot

⚠️ Performance Alert ⚠️

Possible performance regression was detected for benchmark 'pg_search logical-replication.toml Performance - Other Metrics'.
Benchmark result of this commit is worse than the previous benchmark result exceeding threshold 1.10.

Benchmark suite	Current: `e439a8f`	Previous: `c0c03ea`	Ratio
`Index Size Info - Subscriber - segment_count`	`10` median segment_count	`9` median segment_count	`1.11`

This comment was automatically generated by workflow using github-action-benchmark.

CC: @stuhood

paradedb-bot · 2026-01-28T23:56:53Z

…4022) # Description Backport of #4021 to `0.21.x`. Co-authored-by: Stu Hood <[email protected]>

Add support for configurable error skips in stressgres.

e439a8f

stuhood added cherry-pick/0.23.x Request that this PR to `main` should get an automatic cherry-pick PR to `0.23.x` after it lands. cherry-pick/0.22.x Request that this PR to `main` should get an automatic cherry-pick PR to `0.22.x` after it lands. labels Jan 28, 2026

stuhood changed the title ~~Add support for configurable error ignores in stressgres.~~ chore: Add support for configurable error ignores in stressgres. Jan 28, 2026

philippemnoel approved these changes Jan 28, 2026

View reviewed changes

stuhood marked this pull request as ready for review January 28, 2026 22:43

stuhood requested a review from rebasedming as a code owner January 28, 2026 22:43

stuhood added the benchmark-stressgres Add this label to a PR to request that the Stressgres benchmarks run. Automatically removed. label Jan 28, 2026

github-actions bot removed the benchmark-stressgres Add this label to a PR to request that the Stressgres benchmarks run. Automatically removed. label Jan 28, 2026

paradedb-bot reviewed Jan 28, 2026

View reviewed changes

stuhood merged commit 16d3cb8 into main Jan 28, 2026
21 of 22 checks passed

stuhood deleted the stuhood.stressgres-error-skipping branch January 28, 2026 23:03

paradedb-bot pushed a commit that referenced this pull request Jan 28, 2026

chore: Add support for configurable error ignores in stressgres. (#…

ce48cad

…4021) ## What Add support for ignoring configurable error strings. ## Why For use in enterprise. (cherry picked from commit 16d3cb8)

paradedb-bot mentioned this pull request Jan 28, 2026

chore: Add support for configurable error ignores in stressgres. #4022

Merged

paradedb-bot mentioned this pull request Jan 28, 2026

chore: Add support for configurable error ignores in stressgres. #4023

Closed

paradedb-bot reviewed Jan 28, 2026

View reviewed changes

stuhood added a commit that referenced this pull request Jan 29, 2026

chore: Add support for configurable error ignores in stressgres. (#…

a434a51

…4022) # Description Backport of #4021 to `0.21.x`. Co-authored-by: Stu Hood <[email protected]>

mdashti pushed a commit that referenced this pull request Feb 13, 2026

chore: Add support for configurable error ignores in stressgres. (#…

0801574

…4022) # Description Backport of #4021 to `0.21.x`. Co-authored-by: Stu Hood <[email protected]>

Uh oh!

Conversation

stuhood commented Jan 28, 2026

What

Why

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search single-server.toml Performance - TPS

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

⚠️ Performance Alert ⚠️

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search single-server.toml Performance - Other Metrics

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search bulk-updates.toml Performance - TPS

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search bulk-updates.toml Performance - Other Metrics

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search wide-table.toml Performance - TPS

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search wide-table.toml Performance - Other Metrics

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search background-merge.toml Performance - TPS

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search background-merge.toml Performance - Other Metrics

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search logical-replication.toml Performance - TPS

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

pg_search logical-replication.toml Performance - Other Metrics

Uh oh!

paradedb-bot left a comment

Choose a reason for hiding this comment

⚠️ Performance Alert ⚠️

Uh oh!

paradedb-bot commented Jan 28, 2026

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants