ringerc

With reference to prometheus/prometheus#9139

and my comment there prometheus/prometheus#9139 (comment)

Using a non-inverted index for out-of-line storage of long and/or high-churn Prometheus series labels

High level design

To solve the various problems around identifying string-valued labels and differentiating them from normal labels in the TSDB's inverted indexes, support would not be added for string-valued labels in normal selectors; foo{string_label_x=~"a.+"} would find zero results if string_label_x was a special out-of-line stored string label. Instead:

ringerc

# Tests illustrating a bug where histogram samples are incorrectly discarded as out-of-order
# when a load directive contains a single series that combines float and histogram samples
# ( https://github.com/prometheus/prometheus/pull/17021 )
#
# Place in promql/promqltest/testdata/mix_histogram_over_time.test
#
# Run from prometheus source code root dir with
#
#     go test -v -run 'TestEvaluations/testdata/mix_histogram_over_time.test' ./promql
#

ringerc

BEGIN;

SET LOCAL bdr.skip_ddl_locking=on;
SET LOCAL bdr.skip_ddl_replication=on;

CREATE OR REPLACE FUNCTION public.simple_log_row()
RETURNS trigger LANGUAGE plpgsql 
SET search_path = 'pg_catalog'
AS $$
BEGIN

ringerc

                          Phys rep          Phys rep
                          using phys        using
                          slot "B"          phys slot "C"
                +-------+         +--------+         +-------+
 T              |  A    <^--------+ B      <---------+ C     |
 I              |       |         |        |         |       |
 M              +-------+         +--------+         +-------+
 E                 |                  |                  |
 |                 |                  |                  |CREATEs
 |                 |                  |                  |logical slot X

ringerc

From a7a69e8dc87504163222ba2570bda6920114a5c3 Mon Sep 17 00:00:00 2001
From: Craig Ringer <craig@redacted>
Date: Sun, 26 Jun 2016 19:58:48 +0800
Subject: [PATCH] SPK utils build fixes

---
 .gitignore          | 4 ++++
 src/SPK/File_IO.cpp | 2 ++
 src/SPK/Makefile    | 9 +++++----
 src/SPK/String.h    | 3 +++

ringerc

#include "postgres.h"
#include "fmgr.h"

PG_MODULE_MAGIC;

PGDLLEXPORT Datum pg_elephant(PG_FUNCTION_ARGS);
PG_FUNCTION_INFO_V1(pg_elephant);

static const char * const elephant =
"............MMMMMMMMMMM8..........MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM   ...........\n"

ringerc

CREATE TABLE book_lines
(
        id serial primary key,
        book_line text not null
);

ringerc

#!python
# coding=utf-8
#
# usage: python jpegify.py *.pdf
#
# Written for Python 2 or python 3

from __future__ import print_function

import os

ringerc

#!/usr/bin/env python
#
# Disconnect/reconnect each query
#
# Takes 0.45s to run here
#
import time
import psycopg2

start_t = time.time()

ringerc

From 0319a7ecbab5c1e85e300d93f674087786be144a Mon Sep 17 00:00:00 2001
From: Craig Ringer <craig@2ndquadrant.com>
Date: Wed, 1 Apr 2015 10:46:29 +0800
Subject: [PATCH] pg_restore -t should select views, matviews, and foreign
 tables

Currently pg_restore's '-t' option selects only tables, not other
relations. It should be able to match anything that behaves like
a relation in the relation namespace, anything that's interchangable
with a table, including: