digoal/postgres_exam_lib

Stars
53
Rank 549,354 (Top 11 %)
Language
Created over 7 years ago
Updated over 7 years ago

digoal/postgres_exam_lib

digoal

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

PostgreSQL 开放式题库, 搜集自stackoverflow , 社区 , bbs , 微信 , QQ等群体. 帮助大家了解PostgreSQL

blog

OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog

pgsql_admin_script

常用管理脚本

PostgreSQL_HA_with_primary_standby_2vip

A HA script for PostgreSQL with 2 HOST (one for primary, one for standby), Primary with one VIP, Standby with another VIP. Auto failover and failback.

sky_postgresql_cluster

PostgreSQL HA via three host, include two postgresql (primary and stream replication standby) and one vote host.

linux_performance_analyze

Linux's system activity information from sar, this project will use postgresql manage bulk Linux hosts. These hosts registed in postgresql, and every day load it's sar info into postgresql, and use postgresql's SQL analyze the hosts performance, like performance's system activity information and TOP resource consume's hosts, and so on.

gp_tpch

digoal.github.io

sysbench

sysbench for pg,mysql,oracle, support parallel load & prepared test & tablespace & UDF

database_performance_tuning_cases

This project collect Database performance tuning cases from SKY-MOBI DBA Team. Contain mongoDB, PostgreSQL, Oracle, Redis, and so on... Created by Digoal zhou.

sky_monitor_api_by_postgresql

Use PostgreSQL function provide unique Application monitor interface. applications call postgresql function, send status message to it. nagios read the message from postgresql.

oracle_monitor

When we manage many oracle database, the database's status

postgresql_archive_cloud

When we have many and many PostgreSQL Databases, these database's wal archive manage will much complex. We must has a simple manage tool to do it, and it can help us find these databases archive history, analyze which database will use more and which database use few storage to record the wal files. And this tool must can manage these infomation and use storage properly.

postgresql_cloud_database

This project use BIND and PostgreSQL and WEB management TOOL create a large database cloud with PostgreSQL. It's not use OS's Virtual Machine, but Use PostgreSQL's Stream replication failover, so this cloud not depend on Shared Storage and storage's high availability. So it's really a PostgreSQL's cloud system.

postgres_finetuning_kb

PostgreSQL's knowledge base for LLM fine tuning.

VecDB-Exp

mongo_fdw

fork and modified by citusdb's mongo_fdw to support unix sock connection.

postgresql_docker_builder

Build PostgreSQL (with 200+ extenstions and tools) DuckDB MySQL and so on into One docker image. It used for learn database easily only.