M.1. Installation#
The demo database is available atedu.postgrespro.com in three flavors, which differ only in the data size:
demo-small-en.zip (21 MB) — flight data for one month (DB size is about 300 MB)
demo-medium-en.zip (62 MB) — flight data for three months (DB size is about 700 MB)
demo-big-en.zip (232 MB) — flight data for one year (DB size is about 2.5 GB)
The small database is good for writing queries, and it will not take up much disk space. The large database can help you understand the query behavior on large data volumes and consider query optimization.
The files include anSQL script that creates thedemo database and fills it with data (virtually, it is a backup copy created with thepg_dump utility). The owner of thedemo database will be the DBMS user who runs the script. For example, to create the small database, run the script as the userpostgres by means ofpsql:
psql -f demo_small_YYYYMMDD.sql -U postgres
Note that if thedemo database already exists, it will be deleted and recreated!