sudo apt install zsh-autosuggestions zsh-syntax-highlighting zsh
package main | |
import ( | |
"fmt" | |
) | |
type Number interface { | |
~int | ~int8 | ~int16 | ~int32 | ~int64 | |
} |
import time | |
import signal | |
def busy_work(seconds): | |
print("Start busy_work") | |
time.sleep(seconds) | |
print("Stop busy_work") | |
CREATE TABLE large_test (num1 bigint, num2 double precision, num3 double precision); | |
INSERT INTO large_test (num1, num2, num3) | |
SELECT round(random()*10), random(), random()*142 | |
FROM generate_series(1, 20000000) s(i); | |
EXPLAIN (analyse, buffers) | |
SELECT num1, avg(num3) as num3_avg, sum(num2) as num2_sum | |
FROM large_test | |
GROUP BY num1; |