akorotkov

import numpy as np
import faiss
import seaborn as sns
import pandas as pd

# seed RNG for reproducible result
np.random.seed(1234)

nlist = 30

akorotkov

CREATE TABLE test (
    id integer primary key,
    value1 float8 not null,
    value2 float8 not null,
    value3 float8 not null,
    value4 float8 not null,
    ts timestamp not null
);

CREATE INDEX test_value1_idx ON test (value1);

akorotkov

CREATE OR REPLACE FUNCTION int4_to_bytea(int8) RETURNS bytea AS
$BODY$
    SELECT set_byte(' '::bytea, 0, ($1 % 256)::int4) ||
           set_byte(' '::bytea, 0, (($1 / 256) % 256)::int4) ||
           set_byte(' '::bytea, 0, (($1 / 65536) % 256)::int4) ||
           set_byte(' '::bytea, 0, (($1 / 16777216)  % 256)::int4);
$BODY$
LANGUAGE sql;

CREATE OR REPLACE FUNCTION int2_to_bytea(int4) RETURNS bytea AS

akorotkov

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# Draw psql output as iTerm2 v3 inline graph using matplotlib
# Author: Alexander Korotkov <a.korotkov@postgrespro.ru>

import sys
import re
import warnings
import matplotlib
matplotlib.use("Agg")