pg.ddx.io pgdogdev/pgdog GitHub issues and pull requests
help / color / mirror / Atom feedFrom: github-actions[bot] (bot) (@github-actions[bot]) <noreply+github-actions[bot]@github.com>
To: pgdogdev/pgdog <noreply+pgdogdev-pgdog@github.com>
Subject: Re: [pgdogdev/pgdog] PR #2076: security: update outdated dependencies
Date: Thu, 19 Nov 2026 19:53:04 +0000
Message-ID: <gh-pgdogdev-pgdog-2076-c7020479816@github.com> (raw)
In-Reply-To: <gh-pgdogdev-pgdog-2076@github.com>
References: <gh-pgdogdev-pgdog-2076@github.com>
<!-- metal-bench-x86 -->
**Metal bench (x86) failed.** 3 of 520 measures outside bounds.
| suite | throughput | cpu/txn | user cycles/txn | user instr/txn | kernel cycles/txn | kernel instr/txn | ctx/txn |
|---|---|---|---|---|---|---|---|
| pooler | | 25.98 (-0.2% ± 0.3%) | 18,836 (-0.4% ± 0.2%) | 32,945 (+0.4% ± 0.06%) | 33,804 (-0.1% ± 0.3%) | 36,471 (-0.0% ± 0.4%) | |
| lb | | 26.36 (-0.2% ± 0.2%) | 19,382 (-0.6% ± 0.2%) | 33,910 (+0.4% ± 0.04%) | 33,847 (-0.2% ± 0.4%) | 37,196 (+0.1% ± 0.7%) | |
| sharding-w2 | | 42.21 (-0.1% ± 1.2%) | 47,282 (-0.1% ± 0.7%) | 98,855 (+0.1% ± 0.02%) | 38,715 (-0.3% ± 2.7%) | 40,164 (-0.0% ± 0.1%) | 1.524 (-0.1% ± 0.2%) |
| sharding-w8 | 206,029 (-0.1% ± 0.4%) | 33.01 (+0.3% ± 0.7%) | 46,271 (+0.5% ± 1.3%) | 53,221 (+0.3% ± 0.2%) | 31,241 (-0.0% ± 0.2%) | 32,512 (+0.0% ± 0.08%) | 0.172 (-0.5% ± 1.8%) |
<details><summary>Counters per txn</summary>
| suite | frontend stall | l1i refill | backend stall |
|---|---|---|---|
| pooler | 3,797 (-7.9% ± 0.5%) | 1,192 (-4.2% ± 1.0%) | 36,457 (+4.9% ± 0.9%) |
| lb | 3,936 (-9.4% ± 0.5%) | 1,232 (-4.2% ± 0.7%) | 37,474 (+6.0% ± 0.5%) |
| sharding-w2 | 7,032 (-11.1% ± 1.6%) | 1,599 (-2.9% ± 1.6%) | 110,705 (+5.0% ± 3.1%) |
| sharding-w8 | 3,763 (-16.3% ± 1.5%) | 883 (-7.1% ± 1.1%) | 176,858 (+3.6% ± 2.4%) |
</details>
| benchmark | measure | result | baseline | change | bound |
|---|---|---|---|---|---|
| extended_cached::aggregate | instructions | 17,705 | 17,437 | **+1.54% ± 0.00%** | +1% |
| extended_evicting::select_all_shards | instructions | 24,996 | 24,747 | **+1.01% ± 0.00%** | +1% |
| extended_evicting::select_omni | instructions | 22,218 | 21,941 | **+1.26% ± 0.00%** | +1% |
Microbench: 504 of 507 measures within bounds.
<details><summary>Microbench latency: 43 benches changed more than 3%</summary>
| benchmark | latency | baseline | change | instructions change |
|---|---|---|---|---|
| extended_cold::begin | 2,322 ns | 2,114 ns | +9.83% ± 0.66% | +0.00% ± 0.00% |
| extended_cold::set | 2,898 ns | 2,683 ns | +8.03% ± 0.65% | +0.00% ± 0.00% |
| extended_evicting::set | 3,097 ns | 2,884 ns | +7.39% ± 0.78% | +0.00% ± 0.00% |
| simple_cold::begin | 2,090 ns | 1,952 ns | +7.06% ± 0.93% | +0.00% ± 0.00% |
| extended_evicting::begin | 2,468 ns | 2,309 ns | +6.92% ± 1.04% | +0.00% ± 0.00% |
| simple_cold::set | 2,692 ns | 2,549 ns | +5.61% ± 1.20% | +0.00% ± 0.00% |
| simple_cold::order_limit_offset | 9,135 ns | 8,662 ns | +5.46% ± 0.38% | -0.04% ± 0.00% |
| extended_cold::order_limit_offset | 9,226 ns | 8,754 ns | +5.39% ± 0.36% | -0.05% ± 0.00% |
| extended_evicting::distinct | 4,843 ns | 4,614 ns | +4.96% ± 0.91% | +0.00% ± 0.00% |
| extended_cold::insert | 6,982 ns | 6,678 ns | +4.55% ± 0.47% | -0.01% ± 0.00% |
| simple_cold::having | 18,758 ns | 17,968 ns | +4.40% ± 2.21% | +0.13% ± 0.00% |
| extended_evicting::order_limit_offset | 9,491 ns | 9,093 ns | +4.38% ± 0.71% | +0.10% ± 0.00% |
| extended_cold::having_distinct_limit | 25,028 ns | 23,992 ns | +4.32% ± 0.96% | +0.08% ± 0.00% |
| extended_cold::distinct | 4,643 ns | 4,452 ns | +4.27% ± 0.40% | +0.00% ± 0.00% |
| extended_evicting::delete_all_shards | 3,311 ns | 3,179 ns | +4.16% ± 0.58% | +0.00% ± 0.00% |
| extended_cold::insert_returning | 7,942 ns | 7,630 ns | +4.09% ± 0.38% | +0.32% ± 0.00% |
| extended_evicting::select_omni | 4,115 ns | 3,954 ns | +4.07% ± 0.65% | +1.26% ± 0.00% |
| extended_evicting::update_by_key | 4,952 ns | 4,761 ns | +4.02% ± 0.54% | +0.02% ± 0.00% |
| simple_cold::having_distinct_limit | 24,698 ns | 23,746 ns | +4.01% ± 0.78% | +0.06% ± 0.00% |
| extended_cold::delete_all_shards | 3,131 ns | 3,010 ns | +3.99% ± 0.34% | +0.00% ± 0.00% |
| extended_evicting::lookup | 5,770 ns | 5,548 ns | +3.99% ± 0.30% | +0.02% ± 0.00% |
| extended_evicting::insert_split | 17,354 ns | 16,718 ns | +3.81% ± 0.97% | -0.04% ± 0.00% |
| simple_cold::aggregate | 9,203 ns | 8,879 ns | +3.64% ± 1.15% | -0.29% ± 0.00% |
| simple_cold::insert_split | 15,710 ns | 15,158 ns | +3.64% ± 1.02% | +0.11% ± 0.00% |
| extended_cold::having | 18,858 ns | 18,200 ns | +3.62% ± 0.21% | -0.09% ± 0.00% |
| extended_evicting::group_by | 7,004 ns | 6,762 ns | +3.57% ± 0.82% | +0.01% ± 0.00% |
| extended_evicting::insert | 7,176 ns | 6,937 ns | +3.45% ± 1.02% | -0.01% ± 0.00% |
| extended_evicting::select_by_key | 5,375 ns | 5,196 ns | +3.45% ± 0.53% | +0.02% ± 0.00% |
| extended_cold::select_omni | 3,930 ns | 3,801 ns | +3.40% ± 0.47% | +0.00% ± 0.00% |
| simple_cold::select_by_key | 4,998 ns | 4,834 ns | +3.40% ± 1.74% | +0.02% ± 0.00% |
| extended_cold::group_by | 6,804 ns | 6,582 ns | +3.37% ± 0.46% | +0.00% ± 0.00% |
| extended_evicting::update_all_shards | 3,997 ns | 3,868 ns | +3.34% ± 0.87% | +0.00% ± 0.00% |
| extended_evicting::select_all_shards | 4,464 ns | 4,321 ns | +3.30% ± 0.91% | +1.01% ± 0.00% |
| extended_cold::select_by_key | 5,171 ns | 5,012 ns | +3.18% ± 0.55% | +0.02% ± 0.00% |
| extended_evicting::min_max_sum | 8,711 ns | 8,443 ns | +3.17% ± 0.39% | +0.00% ± 0.00% |
| extended_evicting::having_distinct_limit | 25,122 ns | 24,350 ns | +3.17% ± 0.58% | -0.01% ± 0.00% |
| simple_cold::distinct | 4,412 ns | 4,276 ns | +3.17% ± 0.34% | +0.00% ± 0.00% |
| full_named_cached::update_by_key | 12,702 ns | 12,318 ns | +3.12% ± 2.83% | -0.01% ± 0.00% |
| extended_cold::join | 7,882 ns | 7,648 ns | +3.06% ± 0.38% | -0.48% ± 0.00% |
| extended_evicting::having | 19,100 ns | 18,534 ns | +3.05% ± 0.33% | -0.09% ± 0.00% |
</details>
<details><summary>Hot code per txn</summary>
| path | base | head | change |
|---|---|---|---|
| pooler | 116.5 KB | 116.2 KB | **-0.2 KB** |
| sharding-w2 | 170.2 KB | 171.2 KB | **+1.0 KB** |
pooler:
| crate | base | head | change |
|---|---|---|---|
| pgdog::frontend::client::query_engine | 22.7 KB | 22.8 KB | +0.1 KB |
| pgdog::backend::pool | 18.6 KB | 18.6 KB | -0.1 KB |
| tokio | 18.6 KB | 18.3 KB | -0.2 KB |
| pgdog::frontend (other) | 9.8 KB | 9.6 KB | -0.2 KB |
| aws-lc (TLS crypto) | 9.4 KB | 8.6 KB | -0.8 KB |
| rustls (TLS) | 7.8 KB | 8.5 KB | +0.7 KB |
| pgdog::backend::server | 8.0 KB | 8.3 KB | +0.3 KB |
| other | 5.7 KB | 5.8 KB | +0.1 KB |
| everything else | 15.9 KB | 15.8 KB | -0.2 KB |
| function | head | change |
|---|---|---|
| `pgdog::frontend::client::Client::run::{{closure}}` | 7.4 KB | -0.1 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 6.4 KB | -0.2 KB |
| `pgdog::frontend::client::query_engine::QueryEngine::handle::{{closure}}` | 5.1 KB | +0.2 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 4.0 KB | +0.1 KB |
| `tokio::runtime::task::raw::poll` | 3.6 KB | -0.1 KB |
sharding-w2:
| crate | base | head | change |
|---|---|---|---|
| pgdog::frontend::router | 28.1 KB | 28.2 KB | +0.2 KB |
| pgdog::frontend::client::query_engine | 24.1 KB | 24.3 KB | +0.2 KB |
| pgdog::backend::pool | 18.8 KB | 18.8 KB | +0.1 KB |
| tokio | 18.4 KB | 18.6 KB | +0.2 KB |
| pgdog::frontend (other) | 10.8 KB | 10.8 KB | +0.0 KB |
| aws-lc (TLS crypto) | 10.4 KB | 10.6 KB | +0.2 KB |
| other | 10.3 KB | 10.5 KB | +0.2 KB |
| pgdog::backend::server | 8.9 KB | 8.9 KB | -0.1 KB |
| everything else | 40.6 KB | 40.6 KB | +0.0 KB |
| function | head | change |
|---|---|---|
| `pgdog::frontend::client::Client::run::{{closure}}` | 8.2 KB | +0.1 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 6.4 KB | +0.0 KB |
| `pgdog::frontend::client::query_engine::QueryEngine::handle::{{closure}}` | 4.8 KB | +0.1 KB |
| `pgdog::frontend::router::parser::query::select::<impl pgdog::frontend::router::parser::que` | 4.7 KB | +0.2 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 3.9 KB | +0.2 KB |
</details>
<details><summary>lb flamegraph vs 61e9a90b</summary>

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...) for hover, zoom and search.

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...).
</details>
<details><summary>microbench flamegraph vs 61e9a90b</summary>

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...) for hover, zoom and search.

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...).
</details>
<details><summary>pooler flamegraph vs 61e9a90b</summary>

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...) for hover, zoom and search.

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...).
</details>
<details><summary>sharding-w2 flamegraph vs 61e9a90b</summary>

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...) for hover, zoom and search.

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...).
</details>
<details><summary>sharding-w8 flamegraph vs 61e9a90b</summary>

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...) for hover, zoom and search.

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results-x86/meskill-2026-11-19-remove-yon/f70f289aec259a6...).
</details>
<details><summary>Logs</summary>
[lb](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results-x86/meskill-2026-11-19-...), [microbench](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results-x86/meskill-2026-11-19-...), [pooler](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results-x86/meskill-2026-11-19-...), [sharding-w2](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results-x86/meskill-2026-11-19-...), [sharding-w8](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results-x86/meskill-2026-11-19-...), [verdict.json](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results-x86/meskill-2026-11-19-...)
</details>
Compared f70f289a with 61e9a90b on c7i.metal-48xl (on-demand).
view thread (4+ messages)
Message-ID: <gh-pgdogdev-pgdog-2076-c7020479816@github.com>
Permalink: ../gh-pgdogdev-pgdog-2076-c7020479816@github.com/
·
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox