Richard Knop RichardKnop

## bubble_sort.go
package main

import (
	"fmt"
)

func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	bubbleSort(items)
	fmt.Println(items)

## selection_sort.go
package main

import (
	"fmt"
)

func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	selectionSort(items)
	fmt.Println(items)

## insertion_sort.go
package main

import (
	"fmt"
)

func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	insertionSort(items)
	fmt.Println(items)

## shellsort.go
package main

import (
	"fmt"
)

func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	shellshort(items)
	fmt.Println(items)

## comb_sort.go
package main

import (
	"fmt"
)

func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	combsort(items)
	fmt.Println(items)

## merge_sort.go
package main

import (
	"fmt"
)

func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	sortedItems := mergeSort(items)
	fmt.Println(sortedItems)

## query_planner.markdown

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                RichardKnop
                / query_planner.markdown
            
            
              Created
              February 27, 2021 21:24
                — forked from hgmnz/query_planner.markdown
            
              
                PostgreSQL query plan and SQL performance notes
              
          
    Types of index scans

Indexes

Sequential Scan:


Read every row in the table
No reading of index. Reading from indexes is also expensive.
	package main

	import (
	"fmt"
	)

	func main() {
	items := []int{4, 202, 3, 9, 6, 5, 1, 43, 506, 2, 0, 8, 7, 100, 25, 4, 5, 97, 1000, 27}
	bubbleSort(items)
	fmt.Println(items)