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...