mirror of
https://gitlab.com/depesz/explain.depesz.com.git
synced 2024-11-24 08:42:27 +02:00
5fc15d5ed8
We don't have that many of them, but on slow(ish) server dumps or vacuums take long time. Partitioning will make it possible to handle work in smaller increments
63 lines
3.9 KiB
SQL
63 lines
3.9 KiB
SQL
alter table plans."part_0" add check ( substr(id, 1, 1) = '0' );
|
|
alter table plans."part_1" add check ( substr(id, 1, 1) = '1' );
|
|
alter table plans."part_2" add check ( substr(id, 1, 1) = '2' );
|
|
alter table plans."part_3" add check ( substr(id, 1, 1) = '3' );
|
|
alter table plans."part_4" add check ( substr(id, 1, 1) = '4' );
|
|
alter table plans."part_5" add check ( substr(id, 1, 1) = '5' );
|
|
alter table plans."part_6" add check ( substr(id, 1, 1) = '6' );
|
|
alter table plans."part_7" add check ( substr(id, 1, 1) = '7' );
|
|
alter table plans."part_8" add check ( substr(id, 1, 1) = '8' );
|
|
alter table plans."part_9" add check ( substr(id, 1, 1) = '9' );
|
|
alter table plans."part_A" add check ( substr(id, 1, 1) = 'A' );
|
|
alter table plans."part_B" add check ( substr(id, 1, 1) = 'B' );
|
|
alter table plans."part_C" add check ( substr(id, 1, 1) = 'C' );
|
|
alter table plans."part_D" add check ( substr(id, 1, 1) = 'D' );
|
|
alter table plans."part_E" add check ( substr(id, 1, 1) = 'E' );
|
|
alter table plans."part_F" add check ( substr(id, 1, 1) = 'F' );
|
|
alter table plans."part_G" add check ( substr(id, 1, 1) = 'G' );
|
|
alter table plans."part_H" add check ( substr(id, 1, 1) = 'H' );
|
|
alter table plans."part_I" add check ( substr(id, 1, 1) = 'I' );
|
|
alter table plans."part_J" add check ( substr(id, 1, 1) = 'J' );
|
|
alter table plans."part_K" add check ( substr(id, 1, 1) = 'K' );
|
|
alter table plans."part_L" add check ( substr(id, 1, 1) = 'L' );
|
|
alter table plans."part_M" add check ( substr(id, 1, 1) = 'M' );
|
|
alter table plans."part_N" add check ( substr(id, 1, 1) = 'N' );
|
|
alter table plans."part_O" add check ( substr(id, 1, 1) = 'O' );
|
|
alter table plans."part_P" add check ( substr(id, 1, 1) = 'P' );
|
|
alter table plans."part_Q" add check ( substr(id, 1, 1) = 'Q' );
|
|
alter table plans."part_R" add check ( substr(id, 1, 1) = 'R' );
|
|
alter table plans."part_S" add check ( substr(id, 1, 1) = 'S' );
|
|
alter table plans."part_T" add check ( substr(id, 1, 1) = 'T' );
|
|
alter table plans."part_U" add check ( substr(id, 1, 1) = 'U' );
|
|
alter table plans."part_V" add check ( substr(id, 1, 1) = 'V' );
|
|
alter table plans."part_W" add check ( substr(id, 1, 1) = 'W' );
|
|
alter table plans."part_X" add check ( substr(id, 1, 1) = 'X' );
|
|
alter table plans."part_Y" add check ( substr(id, 1, 1) = 'Y' );
|
|
alter table plans."part_Z" add check ( substr(id, 1, 1) = 'Z' );
|
|
alter table plans."part_a" add check ( substr(id, 1, 1) = 'a' );
|
|
alter table plans."part_b" add check ( substr(id, 1, 1) = 'b' );
|
|
alter table plans."part_c" add check ( substr(id, 1, 1) = 'c' );
|
|
alter table plans."part_d" add check ( substr(id, 1, 1) = 'd' );
|
|
alter table plans."part_e" add check ( substr(id, 1, 1) = 'e' );
|
|
alter table plans."part_f" add check ( substr(id, 1, 1) = 'f' );
|
|
alter table plans."part_g" add check ( substr(id, 1, 1) = 'g' );
|
|
alter table plans."part_h" add check ( substr(id, 1, 1) = 'h' );
|
|
alter table plans."part_i" add check ( substr(id, 1, 1) = 'i' );
|
|
alter table plans."part_j" add check ( substr(id, 1, 1) = 'j' );
|
|
alter table plans."part_k" add check ( substr(id, 1, 1) = 'k' );
|
|
alter table plans."part_l" add check ( substr(id, 1, 1) = 'l' );
|
|
alter table plans."part_m" add check ( substr(id, 1, 1) = 'm' );
|
|
alter table plans."part_n" add check ( substr(id, 1, 1) = 'n' );
|
|
alter table plans."part_o" add check ( substr(id, 1, 1) = 'o' );
|
|
alter table plans."part_p" add check ( substr(id, 1, 1) = 'p' );
|
|
alter table plans."part_q" add check ( substr(id, 1, 1) = 'q' );
|
|
alter table plans."part_r" add check ( substr(id, 1, 1) = 'r' );
|
|
alter table plans."part_s" add check ( substr(id, 1, 1) = 's' );
|
|
alter table plans."part_t" add check ( substr(id, 1, 1) = 't' );
|
|
alter table plans."part_u" add check ( substr(id, 1, 1) = 'u' );
|
|
alter table plans."part_v" add check ( substr(id, 1, 1) = 'v' );
|
|
alter table plans."part_w" add check ( substr(id, 1, 1) = 'w' );
|
|
alter table plans."part_x" add check ( substr(id, 1, 1) = 'x' );
|
|
alter table plans."part_y" add check ( substr(id, 1, 1) = 'y' );
|
|
alter table plans."part_z" add check ( substr(id, 1, 1) = 'z' );
|