O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Determining disk usage

In this recipe, we will be discussing the PostgreSQL functionality that measures object size.

Getting ready

PostgreSQL follows a specific file storage layout, which stores data into multiple folders. The common directories that we see in the PostgreSQL data directory are:

  • base: This folder contains the database subfolders and the subfolder will contain actual relational files
  • global: This folder contains all the cluster level catalog information
  • pg_clog: This folder contains the committed transactions information, which will be helpful during crash recovery
  • pg_xlog: This folder contains the ongoing transactions information, which will be helpful during crash recovery
  • pg_tblsp: This folder contains the symbolic link to tablespaces ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required