Categorygithub.com/lpichler/benchmark-sql-spicedb-poc
repositorypackage
0.0.0-20240709080828-bd555a002ce3
Repository: https://github.com/lpichler/benchmark-sql-spicedb-poc.git
Documentation: pkg.go.dev

# Packages

No description provided by the author

# README

This is tool to provide some benchmark tests for fdw-spicedb-poc

This examine performance difference between:

  • Spicedb call

  • Spicedb call with using FDW

  • Join query with results from Spicedb call and join query with using FDW.

There is used items table with generated 10 000 000 records

 CREATE TABLE items (
    ID SERIAL PRIMARY KEY,
    value INTEGER,
    workspace VARCHAR(255)
);

Generated 10 000 000 record.

DO $$
BEGIN
    FOR i IN 1..10000000 LOOP
        INSERT INTO items (value, workspace)
        VALUES (floor(random() * 10000)::int, i || '_test_workspace');
    END LOOP;
END $$;