forked from mtusi2026/mtusi2026lab2
63 lines
1.5 KiB
PL/PgSQL
63 lines
1.5 KiB
PL/PgSQL
|
|
BEGIN;
|
|
|
|
CREATE EXTENSION IF NOT EXISTS pgcrypto;
|
|
|
|
INSERT INTO users (id, username, display_name, password_hash, created_at)
|
|
VALUES (
|
|
'00000000-0000-4000-8000-000000000001',
|
|
'benchmark_user',
|
|
'Benchmark User',
|
|
'benchmark_not_for_login',
|
|
NOW()
|
|
);
|
|
|
|
-- Пять тестовых чатов.
|
|
INSERT INTO chats (id, title, created_at)
|
|
SELECT
|
|
('00000000-0000-4000-8000-' ||
|
|
LPAD(n::text, 12, '0'))::uuid,
|
|
'Benchmark Chat ' || n,
|
|
NOW()
|
|
FROM generate_series(101, 105) AS n;
|
|
|
|
-- Добавляем пользователя в каждый чат.
|
|
INSERT INTO chat_members (chat_id, user_id)
|
|
SELECT
|
|
id,
|
|
'00000000-0000-4000-8000-000000000001'::uuid
|
|
FROM chats
|
|
WHERE title LIKE 'Benchmark Chat %';
|
|
|
|
-- Генерируем 120 000 сообщений.
|
|
-- Распределение: 60k, 30k, 15k, 10k, 5k.
|
|
WITH distribution(chat_num, message_count) AS (
|
|
VALUES
|
|
(101, 60000),
|
|
(102, 30000),
|
|
(103, 15000),
|
|
(104, 10000),
|
|
(105, 5000)
|
|
)
|
|
INSERT INTO messages (
|
|
id,
|
|
chat_id,
|
|
sender_id,
|
|
text,
|
|
created_at
|
|
)
|
|
SELECT
|
|
gen_random_uuid(),
|
|
('00000000-0000-4000-8000-' ||
|
|
LPAD(d.chat_num::text, 12, '0'))::uuid,
|
|
'00000000-0000-4000-8000-000000000001'::uuid,
|
|
'Benchmark message ' || s.n || ' in chat ' || d.chat_num,
|
|
TIMESTAMPTZ '2026-01-01 00:00:00+00'
|
|
+ s.n * INTERVAL '1 second'
|
|
FROM distribution d
|
|
CROSS JOIN LATERAL generate_series(1, d.message_count) AS s(n);
|
|
|
|
COMMIT;
|
|
|
|
ANALYZE messages;
|