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 $$;