Record · corpus.blog/posts/01a0d08a-0273-736b-8d71-bc3531007131

Postgres 17.4 vs sysbench on a large server, revisited

Small Datum · published 15 March 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at smalldatum.blogspot.com Wayback capture

0blogs citing

First cited: —
Most recent: —
Rank this month: not ranked
Links from this post: 28
Words captured: 1,076

Cited by

No blog we hold has cited this post yet.

Links from this post

Link

Host

Postgres 17.4 vs sysbench on a large server Read at the source ↗

smalldatum.blogspot.com

https://github.com/ossc-db/pg_hint_plan/releases

github.com

https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/lua/oltp_read_only.lua

github.com

https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/lua/oltp_common.lua

github.com

https://docs.google.com/spreadsheets/d/1yK7KU6S406XKTgV_rD6eVcdlQgIpUOL4w5ao9B8qoqw/edit?usp=sharing

docs.google.com

https://github.com/mdcallag/mytools/tree/master/bench/arc/mar25.sb.pg.c48

github.com

https://github.com/mdcallag/mytools/blob/master/bench/arc/mar25.sb.pg.c48/dop1/o.met.dop1

github.com

https://github.com/mdcallag/mytools/blob/master/bench/arc/mar25.sb.pg.c48/dop10/o.met.dop10

github.com

https://github.com/mdcallag/mytools/blob/master/bench/arc/mar25.sb.pg.c48/dop20/o.met.dop20

github.com

https://github.com/mdcallag/mytools/blob/master/bench/arc/mar25.sb.pg.c48/dop40/o.met.dop40

github.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBTldE8VHxaPnsy-Rw0hZITNC-bN62_KQsC7N_XYiU-K6SijwkbzI0umh4ijeLUDdnhLGduK-nKijOMAI4H2AdQlAtyaQZD3ywQ0lYpBngr7j-9UX3JvbmmRRKMEkiw_1ha4IGYhfcxIcvH1yaa-vfoX8Iv5YnRfmeb3G0mBnhw-PG43vH0qRzw8IxdVQ6/s600/QPS%20relative%20to%2010.23_%201%20client,%20point%20queries.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhghrAFz5Xe_vZoo8CBP0X7XqAyBgZijym-GOK8Isb-4LPXS8XKD1MiPofv-u0UtkuGPHhwgu3xIHy-ll5SZMDFL3wZo35awnTqfjY0j7IJRuOBrEKOwl8hgjvZQdz2E9m_d4WyFR-ptkLna9hq4bfZtSkHuzZQZI13maonp1PenU8hFyt8fLWhchfP6QtL/s600/QPS%20relative%20to%2010.23_%2010%20clients,%20point%20queries.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3aDzjgyDk0GZX_tly9KQbBE0Jw0LHcZnlDh3Eef9WquGIg9yOXjP1gNGbhwYbnn7cqVY4xwG_WMVSHXfoVMVHqURV9u-TqzguwhkUopvIs6naDVKgNU8efT5MYMo3ZPEPlIINh82mBAVL-czJ84UGuCE700RzoC24iitgYXmJZ69gOk9oG69Gm-kvzOjB/s600/QPS%20relative%20to%2010.23_%2020%20clients,%20point%20queries.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglJn-lvqZDkv8o3leH_fznz7iWJ8jeVUBv84u4ZVEoeo29gIj17vLiYccAf72_KnqxM1yNFv7am-i-jjYpEznfIc8SaEXgzDLixwGTQSIojiWzgzZYqFyA3FG7fbgVXeaJ5-U32dqnh4uBZuaY9FjLxrRRrulYeo92oMK-QmpX-qYS84KKz2EoLyijN1nr/s600/QPS%20relative%20to%2010.23_%2040%20clients,%20point%20queries.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk7w2T0232N4mSMiP6OyfCkZXPrvGdMpDGGcQnsL0V7tR92UZLdrnFs6p9kQ7ZPfNZ0Jd9PPatKFTbzSj6DLtcUpQg_5tSMnTSIr64VUFQGZ7AGTN9Bnn5-gUqWig9Sf3IIllpjT0Vh0LU84CQdsftE02n_Rdo-JLLWHKu1c7Dnlj7FieTfSmY9yjoavMh/s600/QPS%20relative%20to%2010.23_%201%20client,%20range%20queries%20w_o%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtNqXAVWAZtyCqpAD_ZmJVuvT_QadumhCmpYKN85lSFJHQkFlofd6jK2VmsKwl6o8zpd9w9GRaZV3zL8wnacP9hCxarBpY8XaOtYe7omLXUl07OgVjLYe5I6iSQrwzFZ8ji4nbXO9g8AE4RGWXgVRxfHo1zs4gRyy8dPYHGCrjQn6XLhaEN5ELm9S_pcZa/s600/QPS%20relative%20to%2010.23_%2010%20clients,%20range%20queries%20w_o%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6xIySi5Prip7-aR7HLCyHWz92pRWuuA61WLqgqQVYbnZZH8LakF41Hz7OfkkTFw9geyklxDilD-p-hPNb0SvDUAzR83MCQLKwhOmi30awHcYeG5AcSAqC21qKpKBEB2NZ8ntuYLYoBzzzOcZHHnbvv5PmwUHOO5rpAuh-Cmthv_sBSuugIKCjROkRw82h/s600/QPS%20relative%20to%2010.23_%2020%20clients,%20range%20queries%20w_o%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDqeZNtOHuZ8sJ7oHzGUtLp-rLoGM91fUrg0ljYA80mnoox-m_yDy7Q_e7-2Pa4bpYgrMJi6tT77kQpp6Dc3R9GQo1BLnOIjZTZd3vPlwy3YZXN8ij1wXpLg2wkYV3ZdyMvzcCbl57S8ck7B5UPmEuuFa0loJJJs9gybRMaTui_MRAeygyRj7g3V60DiR4/s600/QPS%20relative%20to%2010.23_%2040%20clients,%20range%20queries%20w_o%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOWWcmvmZmdukRULh704-Onu4FjerZSKlHCR7tr4jXOW_f5hOED4M4eR7XTB-bbwSd8v0eDKXV90e9JlaH1YOj2bt2O5Qhtlqu5pax9HDVXHhlphlKikCdtkQsHtnTjY3UXLBheAggbB4s11dccLdSsWhDQmRRNUhyphenhyphenqaeBrNU1iw7-RjZsYtgZPGPgxdDS/s600/QPS%20relative%20to%2010.23_%201%20client,%20range%20queries%20with%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif2ywTdY_JZxofvg7rmhyd7GqsOPyEBEl1IMkdyJ2zKYfnXe_5K_yHGzHwhJxIev7OHsyjt13Yns3vAK3Clx5Y6FK77jiszWVELjjBi4vJgUDzdKJ_wDW1fz8OmtrriL2N5ngE7ATjNDCjQZo5gpzXF3rkPFvnVioFdt-BnaHjiLqsWe3KWtW03hKKE1B9/s600/QPS%20relative%20to%2010.23_%2010%20clients,%20range%20queries%20with%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyNWcJ5T2kS-GrENFver5E6EpvVLsDag7NteH5uXGr2ciTnrsAfI_WLKXa0K6TtJNREHQ-ql-ZoHwyHF4iZAIBuUZFTI68hWYhsXn6Ws5eARCvqmp135nKx7OcbHEFpO7rygRCfKNfIAgUXP6Q1U41k_T6MeBwX__qpGoa5eTPcJ0gIE3AfjJLqpS87haE/s600/QPS%20relative%20to%2010.23_%2020%20clients,%20range%20queries%20with%20aggregation.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhz-z-BUajVaQ9S3SkaD1fyeCTej01gahxSeMDRG0VBq8hJOVkU4MHx9Pi-OVvYD2SUePwyJa64tBebgACkZW1j9RjH6f63IxDesg7sXm2IW9IjMuUO_E7nGGlCKWIJaUVXh47MmuwAXcMzAUprMBKHSVcPm7aa86SuMaLtZguTMDkWL01gZXwQVgK25IS/s600/QPS%20relative%20to%2010.23_%2040%20clients,%20range%20queries%20with%20aggregation.png

blogger.googleusercontent.com

https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/lua/oltp_update_non_index.lua

github.com

https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/all_small.sh.some

github.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdYO1GRQ_lfEr1Fk5awo8UkKQ8dop_RW5JYj7B2yNoTlgNrEIEfx92Xvk-7YrNDcGUn1DJJUaBWz_hlcgn_vTnvUVbLWCGOIJeTsPMU_ZcLxVr9rHv6AFPx0coeTGHYSr3Wbjx7W3GXqNLzEp_gElrrujxnF69ZZpdqhfMH5_LFJhaW3X4S5qaB9oZ3TpZ/s600/QPS%20relative%20to%2010.23_%201%20client,%20writes.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwQsCkY0lN3vOtSXi20q2g4BxS2vmbGtvL_ikIDH4DotZd2P5mWA-EjjdmjNu5Yo6ltIznN2kC8c5NUy4C0muxPt5BgUXgOBgYYf9FTFNdlABMyGpBnW36rphsTjJW5HUwA_B2Vw01nLANATKhCtMFk7Z_2SMIkYLE3Oa1hDNu20FG0KSPlwyWibGKxpPq/s600/QPS%20relative%20to%2010.23_%2010%20clients,%20writes.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcEYWwEEOdjOXb8ZtZaXlkICdu1kgb3ybu49SBGwGH72DZMRVhVXBiiLFWT1h6gOQ9-npPiWkmUvrtaJTb3vlSL8Bd5flmhiAkWAxl0-qeGV0smvNF1cR4Oi86dk_0_6K3KTxJKZ0uq-RFB2Nc3F7WMLd0F47AgGQmYiAh7QuMaBx5sF-NxXdVWeAU99nv/s600/QPS%20relative%20to%2010.23_%2020%20clients,%20writes.png

blogger.googleusercontent.com

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgz0oFwDJRa_ZjU6DY4spfaoyOUABa4ffQEBBI2iG4JHlZBzyRuUHNmrr2gd9dM0fnKdBfEVThesw6vOdRYmfWOSgOIKltj26K7N_Ljoo8Oj-gJpVuG4z7HyMffSUPo_2YQrmNjl3Z43L-RJdxHSijBmkmzBxUN8lhHKzrf3LeQ_lc5YrHRdq9EX8PATmRi/s600/QPS%20relative%20to%2010.23_%2040%20clients,%20writes.png

blogger.googleusercontent.com