A simple case study

In this last section, we will not use the forumdb database. The database we will use instead is called world_temperatures, for which the public data has been imported from the public CSV present at https://www.meteoblue.com/it/tempo/archive/export.

The db-world-temperatures database backup can be found on the packtpub GitHub in the chapter 9 directory, in the file called backup-db-world-temperatures.sql.gz. If you’re using the Docker image, you will already have everything available; otherwise, to import the database, run PostgreSQL on your server:

$ gunzip < backup-db-world-temperatures.sql.gz | psql

If you are using the Docker image, just execute the following:

postgres@learn_postgresql:~$ psql -U postgres world_temperatures

Now, you will have the db-world-temperatures database ready to use. Inside the database, you will find an unpartitioned table named basilea and a partitioned table named basilea_partitioned; both tables contain...