Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: index-bloat

PostgreSQL database size doesn’t match used space on disk

By adminPosted on December 20, 2022

Question : I have a PostgreSQL 9.6 database with high-volume traffic. I run periodically pg_repack reclaim unused space in tables/indexes. […]

Recent Posts

  • Accessing the Oracle cloud with MySQL workbench [closed]
  • Count missing values in each column of the table in PostgreSQL
  • How to restore postgreSQL schema dump to schema with different name
  • How to preserve ID generated from a PRIMARY KEY when moving data into a new table?
  • Why Oracle doesn’t have nolock?
  • SQL Server : speed up this query
  • How to check there is enough disk space before overwriting a DB with restore command
  • Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?
  • copyInSerializer.AddInt32(i)
  • Grant privilege to see column names in null constraint violations when inserting in views
  • Mariadb Galera cluster empty set
  • MongoDB multi-datacenter deployment and shard keys
  • Why is my SQL Server query behaving differently on UPDATE than on SELECT?
  • Postgres: trying to fix some unicode encoding issues
  • ODBC can’t connect to internal MySQL without external network
  • Slow insert in SQL Server 2008
  • Drop partition scheme with orphan indexes
  • Prioritised table query
  • Txn Log backups – does it backup empty space?
  • Need some insights on ‘index_page’ variables in Innodb_Metrics Table

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding