Skip to content

The code from this repository is used to generate or to import the content for the sample queries from PostgreSQL B-Tree Index Explained article

License

Notifications You must be signed in to change notification settings

sebrestin/postgres-btree-dataset

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PostgreSQL B-Tree Index Explained

PostgreSQL B-Tree Index Explained https://www.qwertee.io/blog/postgresql-b-tree-index-explained-part-1/

Install

In order to reproduce the same results as the ones from the article, from PostgreSQL CLI, after connecting to a fresh created database, one can import the data, using the database.sql:

\i database.sql

One can also generate new data by using the create_database.sql, in order to experiment with different data distributions. As with the previous script, a database has to be created before importing the script:

\i create_database.sql

License

MIT © Sebastian Brestin

About

The code from this repository is used to generate or to import the content for the sample queries from PostgreSQL B-Tree Index Explained article

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published