- ~50GB MySQL Application
- Main motivation: PostGis
- Migration made with a custom tool(xml2pgcopy) and mysqldump on 45min
sebastianwebber
/ README.md
Last active
September 19, 2025 14:15
Compilation of the Uber Facts on PostgreSQL to MySQL Migration
. /etc/os-release
sudo sh -c "echo 'deb http://download.opensuse.org/repositories/devel:/kubic:/libcontainers:/stable/xUbuntu_${VERSION_ID}/ /' > /etc/apt/sources.list.d/devel:kubic:libcontainers:stable.list"
wget -nv https://download.opensuse.org/repositories/devel:kubic:libcontainers:stable/xUbuntu_${VERSION_ID}/Release.key -O Release.key
sudo apt-key add - < Release.key
sudo apt-get update -qq
sudo apt-get -qq -y install buildah
``
sebastianwebber
/ top-10-tables_by-size.sql
Created
January 2, 2015 11:43
Listando as 10 maiores tabelas no PostgreSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH table_stats AS ( | |
| SELECT | |
| schemaname, | |
| tablename, | |
| pg_relation_size(schemaname || '.'|| tablename) as table_size, | |
| (pg_total_relation_size(schemaname || '.'|| tablename) - pg_relation_size(schemaname || '.'|| tablename)) as index_size, | |
| pg_total_relation_size(schemaname || '.'|| tablename) as total_size | |
| FROM | |
| pg_tables | |
| ) |
sebastianwebber
/ pg-notify-parallel.go
Last active
September 19, 2024 02:43
postgres listen/notifiy with golang and `go-pg`
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "log" | |
| "time" | |
| "github.com/go-pg/pg" | |
| ) | |
| const maxWorkers = 5 |
sebastianwebber
/ README.md
Last active
February 28, 2024 20:03
PGPool II and PostgreSQL 9.5 on Centos 7
About the virtual machines and network details, see this blog post
Run on both servers:
yum install postgresql95-server postgresql95-contrib pgpool-II-95
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- tested in PostgreSQL 8.4.4 | |
| DROP VIEW IF EXISTS vw_all_table_locks CASCADE; | |
| CREATE VIEW vw_all_table_locks AS | |
| SELECT | |
| pg_namespace.nspname as schemaname, | |
| pg_class.relname as tablename, | |
| pg_locks.mode as lock_type, | |
| age(now(),pg_stat_activity.query_start) AS time_running | |
| FROM pg_class | |
| JOIN pg_locks on pg_locks.relation = pg_class.oid |
sebastianwebber
/ benchmarks.sh
Last active
March 17, 2023 14:33
Run benchmarks on postgres with pgbench
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash -ex | |
| export PGBIN=/usr/pgsql-9.3/bin | |
| export PGUSER=postgres | |
| export PGDATABASE=bench | |
| export DATADIR=/dados/pgbench | |
| export CLUSTER_LOG=/tmp/benchmark.log | |
| export TOTAL_CPUS=$(grep 'cpu cores' /proc/cpuinfo | uniq | awk '{print $NF}') |
sebastianwebber
/ README.md
Last active
July 14, 2022 04:20
enable arm support for docker in fedora 36 on x86_64 machines
From: https://www.stereolabs.com/docs/docker/building-arm-container-on-x86/
-
Install the necessary packages:
sudo dnf install qemu qemu-user-binfmt qemu-user-static
-
Run qemu setup:
sebastianwebber
/ create-ec2-instance-playbook.yml
Last active
May 13, 2022 11:37
Create a EC2 instance with ansible-playbook
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- | |
| - hosts: localhost | |
| connection: local | |
| vars: | |
| gather_facts: False | |
| vars: | |
| keypair: "my-keypair-name" | |
| instance_type: m4.large | |
| security_group: | |
| - "vpc-group-1" |
NewerOlder