pg.ddx.io  pgdogdev/pgdog GitHub issues and pull requests  
help / color / mirror / Atom feed
From: 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 #2058: feat(resharding): add initial setup for resumable resharding tasks
Date: Wed, 18 Nov 2026 13:52:18 +0000
Message-ID: <gh-pgdogdev-pgdog-2058-c6980568792@github.com> (raw)
In-Reply-To: <gh-pgdogdev-pgdog-2058@github.com>
References: <gh-pgdogdev-pgdog-2058@github.com>

<!-- metal-bench -->

**Metal bench (arm64) passed.** All 520 measures within bounds.

| suite | throughput | cpu/txn | user cycles/txn | user instr/txn | kernel cycles/txn | kernel instr/txn | ctx/txn |
|---|---|---|---|---|---|---|---|
| pooler |  | 19.86 (+0.7% ± 2.1%) | 19,049 (+1.1% ± 0.7%) | 31,416 (+0.0% ± 0.08%) | 32,145 (+0.7% ± 3.6%) | 50,843 (-0.1% ± 0.3%) |  |
| lb |  | 20.31 (-0.4% ± 1.4%) | 19,638 (-0.5% ± 2.1%) | 32,295 (-0.0% ± 0.09%) | 32,497 (-0.5% ± 3.1%) | 52,052 (+0.0% ± 0.5%) |  |
| sharding-w2 |  | 35.16 (+5.2% ± 1.3%) | 47,915 (+5.7% ± 0.9%) | 94,899 (-0.0% ± 0.01%) | 44,462 (+6.1% ± 1.7%) | 53,554 (-0.2% ± 0.2%) | 1.529 (-0.9% ± 0.03%) |
| sharding-w8 | 232,825 (-1.7% ± 0.5%) | 31.12 (+2.5% ± 0.3%) | 47,255 (+3.1% ± 1.8%) | 50,509 (+0.0% ± 0.06%) | 38,836 (+1.9% ± 2.6%) | 42,312 (-0.1% ± 0.10%) | 0.1547 (-3.5% ± 3.4%) |

- **sharding-w8**: user cycles +3.1%, instructions flat. Layout, not code.

<details open><summary>Counters per txn</summary>

| suite | frontend stall | l1i refill | backend stall |
|---|---|---|---|
| pooler | 9,343 (+3.2% ± 1.8%) | 2,895 (+1.2% ± 0.8%) |  |
| lb | 9,740 (-0.9% ± 5.3%) | 2,950 (-0.4% ± 2.6%) |  |
| sharding-w2 | 23,567 (+15.8% ± 2.3%) | 4,820 (+8.0% ± 1.2%) |  |
| sharding-w8 | **25,272 (+10.0% ± 5.2%)** | 4,716 (+6.2% ± 3.9%) |  |
</details>

Microbench: all 507 measures within bounds.

<details><summary>Hot code per txn</summary>

| path | base | head | change |
|---|---|---|---|
| pooler | 114.1 KB | 113.4 KB | **-0.7 KB** |
| sharding-w2 | 167.9 KB | 169.8 KB | **+1.9 KB** |

pooler:

| crate | base | head | change |
|---|---|---|---|
| pgdog::frontend::client::query_engine | 19.9 KB | 20.1 KB | +0.2 KB |
| tokio | 18.8 KB | 18.3 KB | -0.4 KB |
| pgdog::backend::pool | 17.8 KB | 17.6 KB | -0.1 KB |
| aws-lc (TLS crypto) | 10.1 KB | 10.4 KB | +0.2 KB |
| rustls (TLS) | 8.3 KB | 8.4 KB | +0.1 KB |
| pgdog::frontend (other) | 7.9 KB | 7.8 KB | -0.1 KB |
| pgdog::backend::server | 7.6 KB | 7.8 KB | +0.2 KB |
| other | 6.4 KB | 6.1 KB | -0.3 KB |
| everything else | 17.3 KB | 16.8 KB | -0.5 KB |

| function | head | change |
|---|---|---|
| `pgdog::frontend::client::Client::run::{{closure}}` | 5.5 KB | -0.1 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 5.3 KB | +0.0 KB |
| `pgdog::frontend::client::query_engine::QueryEngine::handle::{{closure}}` | 4.1 KB | +0.1 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 3.4 KB | +0.1 KB |
| `tokio::runtime::task::raw::poll` | 3.1 KB | +0.0 KB |

sharding-w2:

| crate | base | head | change |
|---|---|---|---|
| pgdog::frontend::router | 29.4 KB | 29.8 KB | +0.4 KB |
| pgdog::frontend::client::query_engine | 20.8 KB | 21.4 KB | +0.6 KB |
| tokio | 18.6 KB | 18.8 KB | +0.2 KB |
| pgdog::backend::pool | 18.1 KB | 18.3 KB | +0.2 KB |
| aws-lc (TLS crypto) | 12.9 KB | 13.1 KB | +0.1 KB |
| other | 9.9 KB | 10.2 KB | +0.2 KB |
| pgdog::frontend (other) | 8.9 KB | 8.9 KB | +0.0 KB |
| rustls (TLS) | 8.1 KB | 8.2 KB | +0.1 KB |
| everything else | 41.1 KB | 41.2 KB | +0.1 KB |

| function | head | change |
|---|---|---|
| `pgdog::frontend::client::Client::run::{{closure}}` | 6.4 KB | -0.1 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 5.1 KB | +0.0 KB |
| `pgdog::frontend::client::query_engine::QueryEngine::handle::{{closure}}` | 4.1 KB | +0.1 KB |
| `pgdog::frontend::router::parser::query::select::<impl pgdog::frontend::router::parser::que` | 3.4 KB | +0.1 KB |
| `pgdog::frontend::client::query_engine::query::<impl pgdog::frontend::client::query_engine:` | 3.4 KB | +0.2 KB |

</details>

<details><summary>lb flamegraph vs 0eda9a90</summary>

![lb](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...) for hover, zoom and search.

![lb removed](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...).
</details>
<details><summary>microbench flamegraph vs 0eda9a90</summary>

![microbench](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...) for hover, zoom and search.

![microbench removed](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...).
</details>
<details><summary>pooler flamegraph vs 0eda9a90</summary>

![pooler](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...) for hover, zoom and search.

![pooler removed](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...).
</details>
<details><summary>sharding-w2 flamegraph vs 0eda9a90</summary>

![sharding-w2](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...) for hover, zoom and search.

![sharding-w2 removed](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...).
</details>
<details><summary>sharding-w8 flamegraph vs 0eda9a90</summary>

![sharding-w8](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...) for hover, zoom and search.

![sharding-w8 removed](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...)

[Open interactive](https://pgdog-metal-bench.s3.amazonaws.com/results/meskill-2026-11-17-other-usu/e0a6ffe0e095c11e41e0...).
</details>

<details><summary>Logs</summary>

[lb](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results/meskill-2026-11-17-othe...), [microbench](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results/meskill-2026-11-17-othe...), [pooler](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results/meskill-2026-11-17-othe...), [sharding-w2](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results/meskill-2026-11-17-othe...), [sharding-w8](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results/meskill-2026-11-17-othe...), [verdict.json](https://s3.console.aws.amazon.com/s3/object/pgdog-metal-bench?prefix=results/meskill-2026-11-17-othe...)
</details>

Compared e0a6ffe0 with 0eda9a90 on m8g.metal-24xl (spot).


view thread (38+ messages)  latest in thread

Message-ID: <gh-pgdogdev-pgdog-2058-c6980568792@github.com>
Permalink:  ../gh-pgdogdev-pgdog-2058-c6980568792@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