Questions tagged [disk-space]

For questions about the storage space used by databases or database objects.

Filter by
Sorted by
Tagged with
0 votes
1 answer
18 views

Is there a way to VACUUM an sqlite3 database in parts to avoid OperationalError: database or disk is full/reduce size of sqlite3 databse

I have a rather large sqlite3 database that I've built/populated through python over a few months. I have done many inserts/deletes etc while putting it together and it now uses the majority of my ...
  • 101
0 votes
1 answer
45 views

VACUUM FULL using another disk

Current database takes almost all of SSD free space ~802GB. 800 GB of memory is taken by single table and it was never vacuumed since 2019. Recently i deleted old rows from the table and now i need to ...
2 votes
1 answer
48 views

SQL Server data file creates 50% unallocated bloat when I create clustered index

My company has relatively large datasets with clustered indexes currently being built on a char(40) field. In order to maintain disk space and streamlining backups, I currently have a "one table ...
0 votes
1 answer
80 views

Drive space issue

Hello I have installed a Zabbix Server 3 months ago with 32GB space disk, I have 200 hosts supervised on this server. And I got this message from the "system information" part :   Error in ...
0 votes
0 answers
20 views

Restoring 2008 R2 db backup to 2019 causes invalid allocated space/free space

3 occasions so far I've been working with legacy 2008 R2 databases that need to be restored to SQL 2019 instances. Each db is at compatibility level 100 on the old instance. Compressed backups being ...
0 votes
1 answer
95 views

How to permanetly turn of transaction logging for specific table in Db2?

In our company we are merging two systems together. Data are required to be moved from Microsoft SQL Server 2016 source database into Db2 v11.5 target database. In production environment this is going ...
  • 99
0 votes
0 answers
195 views

Transaction Logs generated per hr /transaction log disk usage per min/hr in PostgreSQL AWS RDS

Need to estimate the space allocation for transaction logs in AWS RDS PostgreSQL based on the number of logs generated/disk space used for transaction logs per day. I know this information is ...
0 votes
1 answer
118 views

Table with smaller data types seems to take more space on disk?

I have these two identical tables: Table "public.region" Column | Type | Collation | Nullable | Default -------------+----------+-----------+----------+--------- ...
  • 95
2 votes
1 answer
564 views

PostgreSQL crash due to lack of device space

We run PostgreSQL 11 under a CentOS 7 server. Recently, we had several warnings in the log that caused the PostgreSQL server to crash: 2022-05-09 23:26:29 EDT pg_restore db123 132.132.132.32 ...
4 votes
3 answers
1k views

SQL Server / SSMS taking up lots of disk space

I installed SQL Server + SSMS for my univ class and ever since then my disk space is going missing (every so often, approx. 3 gb of space goes missing). I strongly suspect SQL Server and/or SSMS to be ...
1 vote
2 answers
354 views

How to free up hard drive space after deleting millions upon millions of records in mariadb

We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far. ...
5 votes
1 answer
486 views

Does UPDATE write a new row version for unchanged, TOASTed values?

I am working with a PostgreSQL table with a large TEXT field, which is theoretically updated on a regular basis. I have thought about storing the data directly in the filesystem, but with TOAST, the ...
  • 173
0 votes
1 answer
54 views

SSMS -- inhibit results or remove temporary files when query is done

I am running several instances of the same query to establish baselines for potential performance optimization. That is, I want to compare timing for two versions of the same query. I am using SSMS ...
0 votes
1 answer
265 views

Show size of tables and other database objects in Postgres

I need to clear disk space, so I want to see which tables and other objects are using the most disk space in my Postgres databases. Ideally, I'd like to see: database name, schema name, object type, ...
  • 423
2 votes
1 answer
178 views

Postgres WAL full and database stopped/exited with error - No space left on device

I am new to postgresql. We had a full disk issue on PostgreSQL DB where data and WAL was set. WAL was taking almost 65 GB. This is a lower environment and we don't need to restore to a point. Compared ...
0 votes
0 answers
68 views

Excessive TempDB Usage When Using Pivot + Temp Tables

I have a stored procedure that is acting quite strangely, it basically works in this way: --Populate #tmpActualsVertical with data(in this example 84,652,788 rows) SELECT ...
2 votes
2 answers
160 views

Does Postgres protect the hard drive from repeated writes to the same memory cells?

If I have the same row in the same column in the same table to which I write 4 bytes (an integer) 100,000 times a day, will that wear out the SSD? For an SSD 400 kb per day is nothing, yet writing it ...
0 votes
0 answers
36 views

RDS Aurora PostgreSQL took 400GB over time but the database size only 19MB

Already tried to query temporary files (all empty), also replication_slot all empty according to https://aws.amazon.com/premiumsupport/knowledge-center/diskfull-error-rds-postgresql/ Querying database ...
  • 1,261
0 votes
0 answers
128 views

SQL Server 2014 - Disk Space Issue

Currently we have a drive on your server that stores all user DB's data files along with one tempdb data file. (D: drive) It has 1.4 TB total space with only 98Gigs free space. The biggest DB size is ...
0 votes
2 answers
82 views

Free disk space on SQL without impacting application

We have 1 TB disk which is almost full(85%). We're going to free up disk space without any impact on application availability with below approach. Please suggest if this approach looks good or there ...
0 votes
1 answer
173 views

How to reduce big size database files (Data File ) SQL Server without SHRINK?

I found a couple of 'question' regarding shrinking big datafiles but I think that is not very accurate to my situation. So here is my question I have a big database with almost 8TB of Data File Size ...
2 votes
2 answers
515 views

Reduce the size of a primary key Index

I'm using Azure SQL DB and noticed that one of my largest databases appears to have a primary key index with a total size of 6Gb. It's a clustered index on a uniqueidentifier. However, the total rows ...
  • 123
7 votes
2 answers
692 views

Is there a performance or storage space advantage to lowering time/timestamp precision in PostgreSQL?

PostgreSQL allows time/timestamp to specify a precision: time, timestamp, and interval accept an optional precision value p which specifies the number of fractional digits retained in the seconds ...
2 votes
1 answer
99 views

Does a fragmented database cause the transaction log to grow faster?

Hoping to get some clarity here as I've reached the limits of my SQL knowledge. The company I work for sells products storing data in Microsoft SQL Server databases, but our focus isn't really on the ...
0 votes
1 answer
294 views

Limit size of WAL files for PostgreSQL database

I'm using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension. Recently, one of the application migrations has updated the schema of the ...
0 votes
1 answer
226 views

SQL Server data drive (.mdf files) running out of space

We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space. A few weeks ago DB files were shrunk to temporarily ...
0 votes
3 answers
202 views

RMAN configuration suggestions to help save our storage space?

To preface... Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just a junior level. So there is a lot I still don't understand. So I appreciate ...
  • 11
0 votes
1 answer
51 views

Estimate Oracle tablespace required before loading data

I have files ranging from 450 to 750 million rows, which I need to load into our Oracle environment. The DBA asked me to give an estimate on how much tablespace I would need. How to estimate the ...
0 votes
2 answers
51 views

Which Oracle directory takes up the most space and why?

Does any directory file in Oracle occupy the most space? Why does it takes up the most? e.g. system
  • 1
0 votes
0 answers
89 views

Store Elasticsearch shards in separate partitions on data node

I have an Elasticsearch cluster configured with one head node and three data nodes with the number of replicas set to 2. The data nodes are each split into three partitions called /data1 /data2 and /...
  • 211
1 vote
1 answer
553 views

Disk space requirement for REINDEX in Postgresql

There is a server with postres 13 running out of disk space. It contains a table metrics that occupies 90% of the entire database. I have deleted old records in this table. Due to this table is used ...
  • 111
0 votes
1 answer
38 views

How to add a volume to current in use MySQL database

related to the problem I faced here No space left on device, I want to adopt a long term solution about the point no space left on device. One of the action includes to add a volume to the machine in ...
0 votes
1 answer
101 views

Properly delete data forever and free up the space it was using? [duplicate]

I've been having issues finding a real answer to this question as the response is always "Don't do this, it's a bad idea, that space was obviously needed and it will just get used up again in ...
  • 113
0 votes
1 answer
77 views

mysql: ERROR 1040 (HY000): Too many connections and can't restart because of Error: 28 (No space left on device) [closed]

My app crashes because there are too many connections open and mysql does not make me log in as root showing the same problem. After restarting mysql, it does not restart because of no space on disk
2 votes
1 answer
97 views

Oracle: Decreasing PCTFREE on large table

Question about Oracle Database Enterprise Edition version 19.10.0.0.0 running as a standalone instance. I have a table with billions of rows. The table has always had PCTFREE set to 10. It turns out ...
  • 31
5 votes
3 answers
1k views

Size Requirement of SQL Database

I have been asked this question in an interview that how much would be the DB size for a standalone SQL server if 650MB of data is processed every month. I couldn't give any answer to this question in ...
  • 53
0 votes
1 answer
83 views

DB autogrowth issue

I have a database that will growth in 1 month time the autogrowth was set to 500MB but as I monitored it, the consumption is 1GB+ per day. Should I wait for it to auto grow or is it better to set the ...
1 vote
1 answer
48 views

Pointing the database secondary data file towards a network drive

I have a 2 TB database and the Data Drive has filled up. My network team cannot expand the drive nor provide another drive so that the secondary data file can be pointed towards that. My question is ...
  • 1,007
-1 votes
2 answers
46 views

Factorising out repeating data and replacing it with an integer key

I have noticed in my SQLite database that some tables contain columns where many rows usually repeat the same data. Transaction key from_account_key to_account_key timestamp amount data_type data ...
  • 1
0 votes
1 answer
49 views

Disk space efficient foreign key index for insert intensive scientific database?

I'm working tuning a scientific database whose associated simulation is very insert intensive (i.e., run for a long time inserting data, execute summary query at the end). One of the tables is ...
user avatar
0 votes
1 answer
2k views

Drop tables but space not claimed in postgres 12

I have upgraded Postgresql 9.5 to Postgresql 12.4 a few days back using pg_upgrade utility with link (-k) option. So basically I am having two data directories i.e. One is old data directory (v9.5) ...
  • 143
0 votes
1 answer
247 views

Free Drive Space and SQL Server Agent Alerts

I need to receive an email when free drive space on E: or H: becomes less than 20% I know that can be achieved by setting up a job that executes PowerShell or T-SQL scripts on a schedule, that checks ...
0 votes
1 answer
250 views

How can I tell if TempDb is too big?

Let's say that someone wants to follow sage advice and properly setup TempDb and TempDb's log. But let's also say that the chosen sizes are almost certainly too big/aggressive. E.g. pretend we've got ...
  • 111
1 vote
1 answer
358 views

MySQL INFORMATION_SCHEMA.TABLES not adding to file size

I have a file for a table which has grown very large. I expected to have a large amount of unallocated space needing to be optimized, but when checking INFORMATION_SCHEMA.TABLES, there is little ...
3 votes
2 answers
672 views

Monitoring for and dealing with sudden jump in TOAST bloat

I'm trying to diagnose a sudden jump in disk usage in one of my databases (running 11.4). Typically the database grows by ~1 GB per day, but recently in the span of 24h it grew by nearly 100 GB. ...
  • 253
4 votes
1 answer
1k views

Postgresql: Refreshing materialized view fails with "No space left on device" and a huge spike in disk usage

I have a materialized view that refreshes every five minutes. The SQL aggregates the data among many tables with over 800k rows in each. However, the when using the "REFRESH MATERIALIZED VIEW ...
  • 57
0 votes
1 answer
35 views

Create partial index with single value

I have PostgreSQL 12 DB with a table with a several columns, two of them are a bigint ("numCol") and a boolean ("boolCol"). numCol can have any integer number, and 0 is about 0.1%-...
  • 101
2 votes
2 answers
256 views

How to determine or predict space on disk per table row?

I'm very new to Postgres so my math could be off here ... This is my table: CREATE TABLE audit ( id BIGSERIAL PRIMARY KEY, content_id VARCHAR (50) NULL, type VARCHAR (100) NOT NULL, ...
  • 123
2 votes
1 answer
389 views

Reducing table size bytes per row in a simple PostgreSQL database

I have a pretty simple 3 column table in postgresql 11. It's timeseries data and the table can contain many billions of rows. I'm concerned about my table size and total size, and want to optimize my ...
0 votes
1 answer
949 views

MySQL: My table size using a query does not match the IBD's file size on disk

I have a table with about 600 million rows. I ran the following commands and noticed select table_schema "DB name (table_schema)", -> sum((data_length+index_length)/1024/1024/1024) AS "DB ...

1
2 3 4 5
7