Question : Our database is interesting in that we have a large amount of tables that take up a correspondingly […]
Tag: database-size
Database is 300 GB, but I only see small tables?
Question : I wonder why my database is so large. I type: SELECT pg_size_pretty(pg_database_size(‘defaultdb’)); and it says defaultdb is 259 […]
How to handle huge table
Question : We have a problem with a few tables that are very very big slowing down the system. so […]
Is it better to add a data file or better to increase the existing files (MAXSIZE)
Question : I’m quite familiar with SQL-Server as a developer but not so much in the DBA role. Currently I’m […]
Estimate database growth caused by Accelerated Database Recovery
Question : Accelerated Database Recovery (ADR) is on by default in Azure and an option in SQL Server 2019. It […]
Difference in size of table between InnoDB and MEMORY engines
Question : Question The same table stored on hard drive (InnoDB engine) takes 930.72 MB when in Ram (MEMORY engine) […]
PostgreSQL relation size does not sum up
Question : I have a very large table, with blob fields, called data. I’ve tried to figure out why it […]
Schema size [PG TOAST] – PostgreSQL 9.2
Question : I’ve got the following query to measure the schema’s size on my DB: WITH schema_size AS ( SELECT […]
What is the most effective way to manage a community table with one customizable flag?
Question : Fair warning I do not have dba training or anything of the like but I am managing a […]
Find the largest databases on my server
Question : I have several hundred databases running on the same MySQL server. How can I get a list sorted […]