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.1.tar.gz
(16.5 kB
view hashes)
Built Distribution
Close
Hashes for ohmyfpg-0.2.1-cp310-cp310-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9b285de8b71413772f8bd3f9add8f77a0ce7181f089edc959710bd9758d9d386 |
|
MD5 | d803677d242e35188e3d8779da6fa3a0 |
|
BLAKE2b-256 | fd3ed7a057f3448480126ad8e4c82fb1eea74075f27bef03d8773e2d6ba0fa3d |