NikolayS

How to get an estimate of the impact of writing Postgres logs with log_min_duration_statement = 0:

1. Do select pg_stat_statements_reset(); and wait N seconds (where N >> 60 – say 1-24 hours, covering typical busy hours). Remember when it was, and write down somewhere – this timestamp will be needed!

2. Check if select count(*) from pg_stat_statements is lower than pg_stat_statements.max. If it's equal to it, then raise pg_stat_statements.max and restart with the step 1.

3. Get the estimate:

\set TS_PGSS_RESET 'XXXX-XX-XX XX:XX:XX';

Clark-G

TL;DR

Install Postgres 11, and then:

sudo pg_dropcluster 11 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main

atomkirk

defmodule Hungarian do

  @moduledoc """

  Written by Adam Kirk – Jan 18, 2020

  Most helpful resources used:
  https://www.youtube.com/watch?v=dQDZNHwuuOY
  https://www.youtube.com/watch?v=cQ5MsiGaDY8
  https://www.geeksforgeeks.org/hungarian-algorithm-assignment-problem-set-1-introduction/

ayubmalik

package main

import (
	"context"
	"log"
	"strings"
	"time"

	"github.com/aws/aws-sdk-go-v2/aws"
	"github.com/aws/aws-sdk-go-v2/config"