felixge

[
  {
    "Plan": {
      "Node Type": "Nested Loop",
      "Parallel Aware": false,
      "Join Type": "Inner",
      "Startup Cost": 0.01,
      "Total Cost": 12522520.01,
      "Plan Rows": 1000000000,
      "Plan Width": 12,

felixge

[
  {
    "Plan": {
      "Node Type": "Seq Scan",
      "Parallel Aware": false,
      "Relation Name": "congrats_on_loading_your_first_gist",
      "Alias": "congrats_on_loading_your_first_gist",
      "Startup Cost": 0.00,
      "Total Cost": 35.50,
      "Plan Rows": 2550,

felixge

[
  {
    "Plan": {
      "Node Type": "Seq Scan",
      "Parallel Aware": false,
      "Relation Name": "congrats_on_loading_your_first_gist",
      "Alias": "congrats_on_loading_your_first_gist",
      "Startup Cost": 0.00,
      "Total Cost": 35.50,
      "Plan Rows": 2550,

felixge

[
  {
    "Plan": {
      "Node Type": "Nested Loop",
      "Parallel Aware": false,
      "Join Type": "Inner",
      "Startup Cost": 0.01,
      "Total Cost": 20010.01,
      "Plan Rows": 1000000,
      "Plan Width": 8,

felixge

postgres=# \timing
Timing is on.
postgres=# SELECT count(*) FROM generate_series(1, 10000);
 count
-------
 10000
(1 row)

Time: 2.587 ms

felixge

SET search_path=query_test;
DROP SCHEMA IF EXISTS query_test CASCADE;
CREATE SCHEMA query_test;

CREATE TABLE campaigns (
  id int PRIMARY KEY,
  campaign_plan_id int
);

INSERT INTO campaigns VALUES

felixge

SELECT version();
                                                             version
----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 11.5 (Debian 11.5-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
(1 row)

-- Why is this returning true?
-- I think { and [ are considered to sort equally on this machine's `en_US` collation, 
-- so the result is the same as `'{' < '{a'`
SELECT '{' < '[a' COLLATE "en_US";

felixge

SHOW LC_COLLATE;
 lc_collate
-------------
 en_US.UTF-8
(1 row)

EXPLAIN ANALYZE
SELECT g::text FROM generate_series(1, 10000) g ORDER BY 1;
                                                          QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------

felixge

package main

import "fmt"

func main() {
	f1 := &Foo{}
	f2 := &Foo{}
	fmt.Printf("%p = %p\n", f1, f2)

	b1 := &Bar{}

felixge

package main

import (
	"bufio"
	"fmt"
	"io"
	"log"
	"net"
	"os"
	"sync"