Skip to content

A set of psql scripts, used for 100% live demo on PostgreSQL statistics

License

Notifications You must be signed in to change notification settings

msdousti/pg-analyze-training

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

30 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Blog post

Statistics: How PostgreSQL Counts Without Counting

How To

Just run start.sh. It starts a PostgreSQL Docker container using docker compose, and then runs the tutorial on it.

If you don't have Docker, you can adapt start.sh to connect to your favorite PostgreSQL server, but this is NOT RECOMMENDED unless you have a playground instance. This is because the scripts drop and recreate some objects such as the public schema!

The scripts display images using viu. To render the images properly, use a terminal with native support for graphics protocol (e.g., iTerm2 and Kitty), like this:

Key Takeaways

About

A set of psql scripts, used for 100% live demo on PostgreSQL statistics

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published