Support for Distributed DB Without Stored Procedures or functions

[vijivignesh15112013-crypto]

Hi,

I’m exploring HammerDB for benchmarking a distributed Postgres database that does not support stored procedures or functions. Since HammerDB’s workloads (e.g., TPC-C) rely heavily on stored procedures.

I’d like to know , Is there any support or workaround for running HammerDB in environments without procedure/function support?

Any guidance on this .

Thank you

[sm-shaw]

Hi, there was this issue open for external contribution #699 however it was closed as there has been little interest in adding this feature. HammerDB use stored procedures as stored procedures always deliver much higher performance than using client SQL. See the example using MySQL/MariaDB for illustration. Nevertheless this feature can be useful especially if you are not looking at database performance specifically and want to test the network or as you say distributed features. If you are interested in contributing this then the issue can be re-opened.

Otherwise Citus data is a PostgreSQL distributed database that does support stored procedures and HammerDB has built in support for it contributed by Citus https://www.citusdata.com/blog/2023/06/21/distributed-postgres-benchmarks-using-hammerdb-by-gigaom/.

So you could also ask your vendor to support stored procedures and/or if they can't to contribute #699 to HammmerDB so a no stored procedure option is added and their distributed database can be tested.

[vijivignesh15112013-crypto]

Thank you for the response.