Fixup initial provisioning of aio postgres db (#2571) #1056
hinthornwAnnotations
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/aio.py#L1
.........................................
fanout_to_subgraph_10x: Mean +- std dev: 62.0 ms +- 1.6 ms
.........................................
fanout_to_subgraph_10x_sync: Mean +- std dev: 52.1 ms +- 0.8 ms
.........................................
WARNING: the benchmark result may be unstable
* the standard deviation (9.51 ms) is 10% of the mean (94.2 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: 94.2 ms +- 9.5 ms
.........................................
fanout_to_subgraph_10x_checkpoint_sync: Mean +- std dev: 95.8 ms +- 1.7 ms
.........................................
fanout_to_subgraph_100x: Mean +- std dev: 625 ms +- 32 ms
.........................................
fanout_to_subgraph_100x_sync: Mean +- std dev: 511 ms +- 6 ms
.........................................
fanout_to_subgraph_100x_checkpoint: Mean +- std dev: 990 ms +- 44 ms
.........................................
fanout_to_subgraph_100x_checkpoint_sync: Mean +- std dev: 944 ms +- 21 ms
.........................................
react_agent_10x: Mean +- std dev: 31.3 ms +- 0.9 ms
.........................................
react_agent_10x_sync: Mean +- std dev: 22.8 ms +- 0.3 ms
.........................................
react_agent_10x_checkpoint: Mean +- std dev: 47.4 ms +- 0.9 ms
.........................................
react_agent_10x_checkpoint_sync: Mean +- std dev: 37.0 ms +- 0.5 ms
.........................................
react_agent_100x: Mean +- std dev: 345 ms +- 8 ms
.........................................
react_agent_100x_sync: Mean +- std dev: 273 ms +- 4 ms
.........................................
react_agent_100x_checkpoint: Mean +- std dev: 947 ms +- 16 ms
.........................................
react_agent_100x_checkpoint_sync: Mean +- std dev: 847 ms +- 15 ms
.........................................
wide_state_25x300: Mean +- std dev: 24.3 ms +- 0.4 ms
.........................................
wide_state_25x300_sync: Mean +- std dev: 15.5 ms +- 0.2 ms
.........................................
wide_state_25x300_checkpoint: Mean +- std dev: 280 ms +- 4 ms
.........................................
wide_state_25x300_checkpoint_sync: Mean +- std dev: 266 ms +- 3 ms
.........................................
wide_state_15x600: Mean +- std dev: 28.3 ms +- 0.5 ms
.........................................
wide_state_15x600_sync: Mean +- std dev: 17.9 ms +- 0.2 ms
.........................................
wide_state_15x600_checkpoint: Mean +- std dev: 482 ms +- 6 ms
.........................................
wide_state_15x600_checkpoint_sync: Mean +- std dev: 466 ms +- 5 ms
.........................................
wide_state_9x1200: Mean +- std dev: 28.4 ms +- 0.5 ms
.........................................
wide_state_9x1200_sync: Mean +- std dev: 18.1 ms +- 0.4 ms
.........................................
wide_state_9x1200_checkpoint: Mean +- std dev: 315 ms +- 4 ms
.........................................
wide_state_9x1200_checkpoint_sync: Mean +- std dev: 301 ms +- 3 ms
|
|
Comparison against main:
libs/checkpoint-postgres/langgraph/checkpoint/postgres/aio.py#L1
+-----------------------------------------+---------+-----------------------+
| Benchmark | main | changes |
+=========================================+=========+=======================+
| wide_state_15x600_checkpoint | 480 ms | 482 ms: 1.00x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_25x300 | 24.1 ms | 24.3 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_15x600_sync | 17.8 ms | 17.9 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x_sync | 271 ms | 273 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_9x1200 | 28.1 ms | 28.4 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_9x1200_checkpoint_sync | 298 ms | 301 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_15x600 | 28.0 ms | 28.3 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_25x300_sync | 15.4 ms | 15.5 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x_checkpoint | 937 ms | 947 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x | 61.4 ms | 62.0 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x_checkpoint_sync | 837 ms | 847 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x_sync | 51.3 ms | 52.1 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x_checkpoint | 46.7 ms | 47.4 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x | 340 ms | 345 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x | 30.8 ms | 31.3 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x_checkpoint_sync | 36.4 ms | 37.0 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_9x1200_sync | 17.7 ms | 18.1 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x_sync | 22.3 ms | 22.8 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x_sync | 501 ms | 511 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x_checkpoint_sync | 93.3 ms | 95.8 ms: 1.03x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x_checkpoint_sync | 919 ms | 944 ms: 1.03x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x_checkpoint | 91.6 ms | 94.2 ms: 1.03x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x | 594 ms | 625 ms: 1.05x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x_checkpoint | 940 ms | 990 ms: 1.05x slower |
+-----------------------------------------+---------+-----------------------+
| Geometric mean | (ref) | 1.02x slower |
+---------------------------------------
|