Skip to content

Instantly share code, notes, and snippets.

@atkaiser
atkaiser / show_group_by_bug.sql
Created April 22, 2020 06:21
Sample sql script to show how off the postgreSQL query planner can be for group by statements
This file has been truncated, but you can view the full file.
create table user_logins (
user_id bigint,
login_date timestamptz,
info varchar(10)
);
create index find_login on user_logins (user_id, login_date);
insert into user_logins (user_id, login_date, info) values (0, now() - interval '1 min', 'random0');
insert into user_logins (user_id, login_date, info) values (0, now() - interval '2 min', 'random1');
@atkaiser
atkaiser / mixed_rw_1_job_big.fio
Created May 15, 2020 16:50
FIO job file to simulate 1 thread writing and 1 thread reading
[global]
invalidate=1
direct=1
time_based=1
ramp_time=20
blocksize=8k
group_reporting=1
size=32G
[writer]
[global]
invalidate=1
direct=1
time_based=1
ramp_time=20
blocksize=8k
group_reporting=1
size=1G
[writer]
[global]
invalidate=1
direct=1
time_based=1
ramp_time=20
blocksize=8k
group_reporting=1
size=64M
[writer]
[global]
invalidate=1
direct=1
time_based=1
ramp_time=20
blocksize=8k
group_reporting=1
size=2G
[writer]