Create index concurrently #1149
Annotations
1 warning and 2 notices
benchmark
ubuntu-latest pipelines will use ubuntu-24.04 soon. For more details, see https://github.com/actions/runner-images/issues/10636
|
Benchmark results:
libs/checkpoint-postgres/langgraph/checkpoint/postgres/base.py#L1
.........................................
fanout_to_subgraph_10x: Mean +- std dev: 61.7 ms +- 1.4 ms
.........................................
fanout_to_subgraph_10x_sync: Mean +- std dev: 52.3 ms +- 1.0 ms
.........................................
WARNING: the benchmark result may be unstable
* the standard deviation (10.4 ms) is 11% of the mean (95.1 ms)
Try to rerun the benchmark with more runs, values and/or loops.
Run 'python -m pyperf system tune' command to reduce the system jitter.
Use pyperf stats, pyperf dump and pyperf hist to analyze results.
Use --quiet option to hide these warnings.
fanout_to_subgraph_10x_checkpoint: Mean +- std dev: 95.1 ms +- 10.4 ms
.........................................
fanout_to_subgraph_10x_checkpoint_sync: Mean +- std dev: 95.7 ms +- 2.1 ms
.........................................
fanout_to_subgraph_100x: Mean +- std dev: 648 ms +- 30 ms
.........................................
fanout_to_subgraph_100x_sync: Mean +- std dev: 513 ms +- 6 ms
.........................................
fanout_to_subgraph_100x_checkpoint: Mean +- std dev: 1.05 sec +- 0.06 sec
.........................................
fanout_to_subgraph_100x_checkpoint_sync: Mean +- std dev: 962 ms +- 25 ms
.........................................
react_agent_10x: Mean +- std dev: 31.8 ms +- 0.8 ms
.........................................
react_agent_10x_sync: Mean +- std dev: 23.1 ms +- 0.3 ms
.........................................
react_agent_10x_checkpoint: Mean +- std dev: 48.7 ms +- 1.1 ms
.........................................
react_agent_10x_checkpoint_sync: Mean +- std dev: 37.1 ms +- 0.8 ms
.........................................
react_agent_100x: Mean +- std dev: 346 ms +- 7 ms
.........................................
react_agent_100x_sync: Mean +- std dev: 275 ms +- 4 ms
.........................................
react_agent_100x_checkpoint: Mean +- std dev: 973 ms +- 11 ms
.........................................
react_agent_100x_checkpoint_sync: Mean +- std dev: 878 ms +- 9 ms
.........................................
wide_state_25x300: Mean +- std dev: 24.5 ms +- 0.4 ms
.........................................
wide_state_25x300_sync: Mean +- std dev: 15.7 ms +- 0.2 ms
.........................................
wide_state_25x300_checkpoint: Mean +- std dev: 282 ms +- 5 ms
.........................................
wide_state_25x300_checkpoint_sync: Mean +- std dev: 270 ms +- 4 ms
.........................................
wide_state_15x600: Mean +- std dev: 28.8 ms +- 0.5 ms
.........................................
wide_state_15x600_sync: Mean +- std dev: 18.3 ms +- 0.2 ms
.........................................
wide_state_15x600_checkpoint: Mean +- std dev: 490 ms +- 7 ms
.........................................
wide_state_15x600_checkpoint_sync: Mean +- std dev: 470 ms +- 8 ms
.........................................
wide_state_9x1200: Mean +- std dev: 28.8 ms +- 0.6 ms
.........................................
wide_state_9x1200_sync: Mean +- std dev: 18.3 ms +- 0.2 ms
.........................................
wide_state_9x1200_checkpoint: Mean +- std dev: 319 ms +- 4 ms
.........................................
wide_state_9x1200_checkpoint_sync: Mean +- std dev: 303 ms +- 4 ms
|
Comparison against main:
libs/checkpoint-postgres/langgraph/checkpoint/postgres/base.py#L1
+-----------------------------------------+---------+------------------------+
| Benchmark | main | changes |
+=========================================+=========+========================+
| wide_state_25x300_sync | 15.6 ms | 15.7 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_9x1200_sync | 18.2 ms | 18.3 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| react_agent_100x_sync | 273 ms | 275 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_15x600_checkpoint_sync | 467 ms | 470 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_25x300_checkpoint_sync | 268 ms | 270 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| fanout_to_subgraph_100x_sync | 509 ms | 513 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_25x300 | 24.3 ms | 24.5 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_25x300_checkpoint | 279 ms | 282 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_9x1200_checkpoint | 315 ms | 319 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_9x1200_checkpoint_sync | 300 ms | 303 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| react_agent_10x | 31.4 ms | 31.8 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| fanout_to_subgraph_100x_checkpoint_sync | 949 ms | 962 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| react_agent_10x_sync | 22.8 ms | 23.1 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_15x600 | 28.3 ms | 28.8 ms: 1.01x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_15x600_checkpoint | 483 ms | 490 ms: 1.02x slower |
+-----------------------------------------+---------+------------------------+
| react_agent_10x_checkpoint | 47.9 ms | 48.7 ms: 1.02x slower |
+-----------------------------------------+---------+------------------------+
| wide_state_15x600_sync | 18.0 ms | 18.3 ms: 1.02x slower |
+-----------------------------------------+---------+------------------------+
| react_agent_100x_checkpoint | 951 ms | 973 ms: 1.02x slower |
+-----------------------------------------+---------+------------------------+
| fanout_to_subgraph_100x | 627 ms | 648 ms: 1.03x slower |
+-----------------------------------------+---------+------------------------+
| react_agent_100x_checkpoint_sync | 848 ms | 878 ms: 1.04x slower |
+-----------------------------------------+---------+------------------------+
| fanout_to_subgraph_100x_checkpoint | 989 ms | 1.05 sec: 1.06x slower |
+-----------------------------------------+---------+------------------------+
| Geometric mean | (ref) | 1.01x slower |
+-----------------------------------------+---------+------------------------+
Benchmark hidden because not significant (7): fanout_to_subgraph_10x, react_agent_100x, react_agent_10x_checkpoint_sync, fanout_to_subgraph_10x_sync, wide_state_9x1200, fanout_to_subgraph_10x_checkpoint_sync, fanout_to_subgraph_10x_checkpoint
|