Fixup initial provisioning of aio postgres db (#2571) #1062
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/__init__.py#L1
.........................................
fanout_to_subgraph_10x: Mean +- std dev: 61.2 ms +- 1.6 ms
.........................................
fanout_to_subgraph_10x_sync: Mean +- std dev: 51.5 ms +- 1.7 ms
.........................................
fanout_to_subgraph_10x_checkpoint: Mean +- std dev: 92.6 ms +- 8.8 ms
.........................................
fanout_to_subgraph_10x_checkpoint_sync: Mean +- std dev: 93.5 ms +- 2.1 ms
.........................................
fanout_to_subgraph_100x: Mean +- std dev: 608 ms +- 25 ms
.........................................
fanout_to_subgraph_100x_sync: Mean +- std dev: 500 ms +- 6 ms
.........................................
fanout_to_subgraph_100x_checkpoint: Mean +- std dev: 933 ms +- 49 ms
.........................................
fanout_to_subgraph_100x_checkpoint_sync: Mean +- std dev: 914 ms +- 17 ms
.........................................
react_agent_10x: Mean +- std dev: 30.8 ms +- 0.6 ms
.........................................
react_agent_10x_sync: Mean +- std dev: 22.5 ms +- 0.5 ms
.........................................
react_agent_10x_checkpoint: Mean +- std dev: 46.9 ms +- 1.0 ms
.........................................
react_agent_10x_checkpoint_sync: Mean +- std dev: 37.0 ms +- 0.4 ms
.........................................
react_agent_100x: Mean +- std dev: 342 ms +- 7 ms
.........................................
react_agent_100x_sync: Mean +- std dev: 270 ms +- 6 ms
.........................................
react_agent_100x_checkpoint: Mean +- std dev: 922 ms +- 8 ms
.........................................
react_agent_100x_checkpoint_sync: Mean +- std dev: 822 ms +- 7 ms
.........................................
wide_state_25x300: Mean +- std dev: 23.8 ms +- 0.4 ms
.........................................
wide_state_25x300_sync: Mean +- std dev: 15.3 ms +- 0.3 ms
.........................................
wide_state_25x300_checkpoint: Mean +- std dev: 276 ms +- 4 ms
.........................................
wide_state_25x300_checkpoint_sync: Mean +- std dev: 264 ms +- 4 ms
.........................................
wide_state_15x600: Mean +- std dev: 27.8 ms +- 0.7 ms
.........................................
wide_state_15x600_sync: Mean +- std dev: 17.7 ms +- 0.4 ms
.........................................
wide_state_15x600_checkpoint: Mean +- std dev: 478 ms +- 5 ms
.........................................
wide_state_15x600_checkpoint_sync: Mean +- std dev: 464 ms +- 4 ms
.........................................
wide_state_9x1200: Mean +- std dev: 28.2 ms +- 0.6 ms
.........................................
wide_state_9x1200_sync: Mean +- std dev: 17.7 ms +- 0.2 ms
.........................................
wide_state_9x1200_checkpoint: Mean +- std dev: 311 ms +- 3 ms
.........................................
wide_state_9x1200_checkpoint_sync: Mean +- std dev: 297 ms +- 6 ms
|
|
Comparison against main:
libs/checkpoint-postgres/langgraph/checkpoint/postgres/__init__.py#L1
+-----------------------------------------+---------+-----------------------+
| Benchmark | main | changes |
+=========================================+=========+=======================+
| react_agent_100x_checkpoint | 929 ms | 922 ms: 1.01x faster |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x_checkpoint_sync | 828 ms | 822 ms: 1.01x faster |
+-----------------------------------------+---------+-----------------------+
| wide_state_25x300_checkpoint | 278 ms | 276 ms: 1.00x faster |
+-----------------------------------------+---------+-----------------------+
| wide_state_9x1200_sync | 17.6 ms | 17.7 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x | 30.6 ms | 30.8 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x_sync | 268 ms | 270 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_15x600_sync | 17.6 ms | 17.7 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x_sync | 497 ms | 500 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_100x | 339 ms | 342 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x_checkpoint_sync | 905 ms | 914 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x | 60.6 ms | 61.2 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x_sync | 50.8 ms | 51.5 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x_checkpoint | 46.3 ms | 46.9 ms: 1.01x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x_sync | 22.1 ms | 22.5 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| wide_state_9x1200 | 27.7 ms | 28.2 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x_checkpoint_sync | 92.0 ms | 93.5 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| react_agent_10x_checkpoint_sync | 36.2 ms | 37.0 ms: 1.02x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_10x_checkpoint | 90.0 ms | 92.6 ms: 1.03x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x_checkpoint | 881 ms | 933 ms: 1.06x slower |
+-----------------------------------------+---------+-----------------------+
| fanout_to_subgraph_100x | 571 ms | 608 ms: 1.07x slower |
+-----------------------------------------+---------+-----------------------+
| Geometric mean | (ref) | 1.01x slower |
+-----------------------------------------+---------+-----------------------+
Benchmark hidden because not significant (8): wide_state_15x600, wide_state_25x300_checkpoint_sync, wide_state_25x300, wide_state_15x600_checkpoint_sync, wide_state_9x1200_checkpoint, wide_state_9x1200_checkpoint_sync, wide_state_15x600_checkpoint, wide_state_25x300_sync
|