From 637302a61ee9b4ef84e5c152a17af442599a8e2a Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 29 Sep 2025 18:42:44 +0200 Subject: Draft ready for PostgreSQL aggregation processing speed --- content/posts/nested-postgres-results/setup.sql | 26 ------------------------- 1 file changed, 26 deletions(-) delete mode 100644 content/posts/nested-postgres-results/setup.sql (limited to 'content/posts/nested-postgres-results/setup.sql') diff --git a/content/posts/nested-postgres-results/setup.sql b/content/posts/nested-postgres-results/setup.sql deleted file mode 100644 index a54563b..0000000 --- a/content/posts/nested-postgres-results/setup.sql +++ /dev/null @@ -1,26 +0,0 @@ -CREATE TABLE accommodations ( - id serial PRIMARY KEY, - name text NOT NULL, - default_price numeric(10, 2) NOT NULL -); - -INSERT INTO accommodations (name, default_price) -SELECT - CONCAT('accommodation_', generate_series) AS name, - TRUNC(RANDOM() * 100 + 200) AS default_price -FROM GENERATE_SERIES(1, 10000); - -CREATE TABLE overrides ( - id serial PRIMARY KEY, - accommodation_id integer NOT NULL REFERENCES accommodations (id), - date date NOT NULL, - price numeric(10, 2) NOT NULL -); -ALTER TABLE overrides ADD constraint unique_dates UNIQUE ( - accommodation_id, date -); -INSERT INTO overrides (accommodation_id, date, price) SELECT - (generate_series / 100) + 1 AS accommodation_id, - '2025-01-01'::date + (generate_series % 100) * '3 days'::interval AS date, - TRUNC(RANDOM() * 100 + 200) AS price -FROM GENERATE_SERIES(1, 999999); -- cgit v1.3