Oh My Fast Postgres!
Project description
Oh My Fast Postgres!
Oh My Fast Postgres!
Basic benchmarking
docker run -p 5432:5432 --name rust-postgres -e POSTGRES_PASSWORD=postgres -d postgres -c log_min_messages=DEBUG5
Data preparation:
CREATE TABLE performance_test (id INT, foo_bar_int2 INT2, foo_bar_int4 INT4, foo_bar_int8 INT8, foo_bar_float4 FLOAT4, foo_bar_float8 FLOAT8);
INSERT INTO performance_test (
id,
foo_bar_int2,
foo_bar_int4,
foo_bar_int8,
foo_bar_float4,
foo_bar_float8
) VALUES (
generate_series(1, 1000000),
trunc(random() * (2*32768) - 32768),
trunc(random() * (2*2147483648) - 2147483648),
trunc(random() * (2*9223372036854775808) - 9223372036854775808),
trunc(random()),
trunc(random())
);
maturin develop --release --manifest-path ohmyfpg/Cargo.toml
python python/examples/simple_query.py
RUST_BACKTRACE=1 cargo run -r -p ohmyfpg_core --example simple_query
Basic profiling
sudo CARGO_PROFILE_BENCH_DEBUG=true RUST_BACKTRACE=1 cargo flamegraph -p ohmyfpg_core --example simple_query
Performance comparison
python performance/compare.py
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ohmyfpg-0.2.0.tar.gz
(16.5 kB
view hashes)
Built Distribution
Close
Hashes for ohmyfpg-0.2.0-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a03072c42bed8a14364dd2ecfeabf54db95c1435598f3fecbec0701b5c4db566 |
|
MD5 | 09a1a2557ccd29cefd27037bbec9d06a |
|
BLAKE2b-256 | 75ac6f43fbe96c5bffd12eb6deec36fd7275ac4d612c8e82944ab1e39098773d |