Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [disk-space]

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

1
vote
0answers
17 views

Which PgBackRest policy for differential backups in PostgreSQL

I set up pgBackRest and PostgreSQL configuration in two differents servers. I set up with crontab one full backup a week and one differential backup a day. 0 1 * * 0 pgbackrest --type=...
0
votes
2answers
36 views

Does adding a postgres index concurrently take up disk space gradually or all at once?

I'm adding a unique index (concurrently, over the course of hours or maybe even days, on a column of 5 billion bigints, all of them NULL) on a Postgres 9.6 server that's pretty low on disk space. I ...
0
votes
1answer
48 views

Checking space availability before a VACUUM FULL (postgres)

Is it possible to check how much re-usable space is available in a tablespace before running a VACUUM FULL on a large table? I have a large postgres table (about 20G) that gets an occasional VACUUM ...
0
votes
1answer
15 views

During table migration of tables from one tablespace to another, does it needs free space to do the alter table move?

During migration of tables from one tablespace to another (all datafiles in the same disk/partition/mount), does it needs free space to do the alter table move? exemple:. I have 30gb of free space on ...
0
votes
2answers
40 views

Moving tables to new tablespace needs temp space or any kind of addictional space? (Oracle 11g)

I've been trying to search for this info on oracle documents but they just don't talk about it. I need to move about 2TB of different tables from 3 different tablespaces to a new tablespace (...
0
votes
0answers
50 views

How to manage Oracle diagnostics logs not managed by adrci?

How can I identify Oracle log files that are not managed by adrci? I wish to manage disk space usage, in a similar scenario to this article: "How to free up disk space? which logs/directories to ...
-4
votes
1answer
60 views

PRODUCTION DATABASE RUNNING OUT OF SPACE [closed]

My database has 9556.97MB of space left. I do have about 2TB free disk space. The database is in full recovery mode and doing full backup everyday, also TLOG backup every 24 minutes. I used to just ...
5
votes
2answers
493 views

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

If I size my log files to evenly split the entire drive they reside on, leaving no extra space available, will log backups still be able to occur successfully? I have several databases, with one log ...
1
vote
0answers
29 views

Why is my InnoDB table size so much larger than the data?

I have a MySQL table (version 8.0.13). One table is unreasonably large and doesn't correspond to the current data. I rebuilt the table by running ALTER TABLE users FORCE and OPTIMIZE TABLE users, but ...
0
votes
0answers
96 views

Mongoexport and mongodump disk usage rationale

I just had an interesting experience with the mongoexport tool and came out with a doubt about the exporting process' disk usage. I was trying to dump a 50 MB collection to a disk that had 3 GB free ...
-1
votes
1answer
36 views

Database volume completely full

/dev/mapper/pgdatavg-base 138304552 131262788 16384 100% /var/lib/pgsql/data/base pg_xlog is on a separate volume, and it's got plenty of space. [postgres@fpslbxmbstgl05 ...
1
vote
0answers
33 views

One of the mongo shards consuming too much disk space.

We have mongo cluster with 10 shards of each having 3 replicas. Recently we are facing an issue, exceptionally in a couple of shards, the disk space among all the 3 replicas has reached above 90%. ...
2
votes
1answer
226 views

Mongodb replica set primary and secondary node conf fail when one slave is down

In my env, I had created MongoDB replica set conf for high availability so one server fails should be handled by other also in my conf I have 3 DB server and 1 arbiter too but, my slave's server ...
0
votes
1answer
51 views

why when I change a column from DATETIME to DATE, I can't see any storage improvement?

Long story short. I have a table with more than 10millions rows with a datetime field. WE can change that to DATE ( because date uses 3bytes, and datetime 8). I thought if I: alter table table1 ...
2
votes
2answers
76 views

Upgrade in-place with low disk space on C: drive

I am due to upgrade SQL Server 2005 Express to 2014 Express. This will be an in-place upgrade. It's not my preferred way of upgrading, but being a physical machine and in a specific secure network ...
1
vote
1answer
39 views

Why does this tsvector update use so much space?

This is my table structure: Column | Type | Collation | Nullable | Default | Storage | Stats target | Description -------------+---------------...
1
vote
1answer
39 views

Use T-SQL to return free space on a network share

I'd like to be able to calculate the amount of free space I have for offsite backups so I can prevent any jobs from running should there not be the relevant space and also be able to send alerts when ...
-2
votes
2answers
755 views

How to query system specs (cpu, memory, data disks, free space) using t-sql [closed]

Is there an ability to query below system specifications using t-sql ? 1. cpu (show number of processors / cores / frequency) 2. memory (show total amount of RAM on a machine; show allocated RAM; ...
2
votes
3answers
182 views

How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?

I have a database whose initial size is set to 1000 GB. Is there a way where i can set an alert when the max space is used and database size is nearing to 1000 GB, for eg when it reaches maybe 995 or ...
0
votes
2answers
172 views

Impact on database while increasing database initial size

I have a database whose initial size is 900 GB for .mdf file and 13 GB for log file, I want to increase its initial size to + 100 GB , while doing that in the properties -> filegroup->initial size, do ...
0
votes
1answer
240 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...
0
votes
2answers
48 views

Drive holding my database is running out of space. What are my options?

I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:) and it has 50GB left. I've only ...
1
vote
1answer
103 views

Is there any string compaction option for PostgreSQL?

I have a table like this: CREATE TABLE BLOG( CATEGORY CHAR(32) ); Category is a column, which stored enum values. For example, I have 1 millions of rows and 10 unique values of Category. Let'...
-1
votes
1answer
189 views

Allocation of disk space to new created databases in production [closed]

Our current production database has total disk space of 2 TB. (SQL Serve 2012 standard RTM version.) Currently we have database size allocation as attached. Apart from FUNDSDB and DBAdmin, remaining ...
0
votes
1answer
117 views

Autogrowth Analysis in PROD DB based on the trace file data

I have used the below query to check our Production Database Autogrowth events so that we can set to a value which is much more realistic than the current value of 200 mb , unrestricted for mdf file ...
1
vote
2answers
424 views

Recommended Auto Grow settings suitable for database whose size is 867666.25 MB [closed]

I need recommendations for setting/modifying the auto grow options for our production database. size of FUNDSDB 867666.25 MB Also, I have attached the current autogrowth statistics , looks like ...
2
votes
1answer
288 views

Implementing disk quota for MariaDB

I want my Linux MariaDB database to have disk quota implemented. How can I achieve this these days? I have found some tools but they are for MySQL, don't know if they are supposed to work on ...
2
votes
1answer
63 views

Where in the database file is an index rebuild started? Alternative to SHRINKFILE?

When rebuilding an index in SQL server, where in the datafile does it put that data? Does it start at the beginning of free space and fill in the gaps from there? Context: I have some large .ndf ...
1
vote
1answer
36 views

Guideline for MySQL free space

What is the guideline for how much free space to keep available on a MySQL AWS RDS instance (SSD)? In the past for an on-premises SQL Server install we used to use something like 2x the largest table ...
2
votes
1answer
80 views

Disk Architecture on SQL Server [closed]

I am building a new environment using the SQL Server 2017 Always-On system. This will be active 24/7 and there will be lots of DML processes. I have a 100GB SAS for the OS, a 1TB SAS for Data and a ...
0
votes
0answers
53 views

Expanding Cluster Drive space

I will need to expand my existing cluster drive (sql cluster with 2 node active and passive) which has sys and user database data files. My san admin told he will need to delete all the existing data ...
0
votes
1answer
261 views

Reduced copy of zabbix database

I've a relatively big postgresql database that tooks a lot of space in a server. The database stores a zabbix system used to monitor data that I've to safely keep, so history tables are quite big. My ...
1
vote
1answer
58 views

Not find the table of the oid

I have a database running under PostgreSQL which normally has to have a size of 300 GB. Unfortunately it is now 3,5 TB in size. I noticed that the directory of this database , the pgdata path is /...
7
votes
2answers
4k views

what is the best practice for tempdb autogrowth?

I have a client's server with about 15 databases on this instance with a data total of about 100 GB. One of the databases is for a sysaid app. his temp db files are one mdf one ndf and of course an ...
8
votes
1answer
3k views

If no plans to uninstall, can Log and Update Cache folders in Setup Bootstrap folder be removed?

I have several versions of SQL Server, used for testing, installed on my laptop (2012, 2014, 2016, and 2017). I noticed the other day that there was a folder containing prior versions of files across ...
0
votes
1answer
78 views

Back Up - Free Drive Space

Is there a way to know the free disk space available on the drive that the back up file will be created? For example, SQL Server is installed in Server 1 and the back up file is scheduled to be ...
0
votes
2answers
1k views

SQL Server 2016 out of disk space

I'm running SQL Server 2016. I have a database that has run, apparently, out of space on the D: drive. The daily index rebuild started producing the error shown below. Msg 1101, Level 17, State 12, ...
1
vote
1answer
98 views

Decrease size of database (with an expression index)?

This is my current table definition in a Postgres 10.1-1 database: CREATE TYPE CUSTOMER_TYPE AS ENUM ('enum1', 'enum2', 'enum3', '...', 'enum15'); -- max length of enum names ~15 CREATE TABLE ...
0
votes
2answers
377 views

Purging Binary Logs from Master in a Replication Environment

Replication Set up 6 Masters and their respective Slave. All 6 slaves writing to a Master - which has its own Slave. Now, I want to purge binary logs on the 6 original masters and set expiry to 15 ...
10
votes
2answers
3k views

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

In our environment the network storage is low on space. At the same time I would like to make sure that we take transaction log backups every 15 minutes instead of current every 6 hours. My question ...
2
votes
3answers
181 views

Why does my DELETE command require huge amount of temporary run storage?

I am trying to perform a cleanup operation on a table using DELETE and I receive the following error: Could not allocate space for object 'dbo.SORT temporary run storage: 140767697436672' in ...
1
vote
1answer
284 views

How to reclaim unused space from clustered index table

I have a clustered index table with more than 11,000,000 records running on SQL Server 2008 R2 Standard Edition. I have noticed the table has about 90 GB of free space. This is the table definition: ...
0
votes
1answer
823 views

Freeing unallocated space

I have a server that the database drive is running out of space. i have deleted some of the old log data and historical data to try and free up the space.what is the best way to free allocated space ...
2
votes
1answer
70 views

How does combining columns save disk space?

I am creating a table in SQL server and inserting records. Three columns from this table are AAA int, AAB int and AAC int. If I merge AAB and AAC into one column Comb1 char(2), it consumes 20% less ...
1
vote
1answer
511 views

How to Determine Optimal Disk Cluster Size for Firebird 2.5

I'm using Firebird 2.5.6 Classic Server on a Windows 7 64-bit machine. We're moving the database to a separate disk (32GB NTFS Volume) and are now provisioning that disk. My question is, what should ...
5
votes
0answers
1k views

VARCHAR(MAX) taking more space than NVARCHAR(MAX) [duplicate]

I have a table in SQL Server 2012 Enterprise Edition that has ~100GB of data. Most of this data is attributed to a single NVARCHAR(MAX) column which has an average length of 4500 characters. It stores ...
3
votes
1answer
603 views

How does SQL Server reuse reserved pages after deleting a table

I just want to know: How SQL Server reuses reserved space after dropping a 1GB table? (call the table T1) How SQL Server reuses reserved space after truncating a table? (call this table T2) Both are ...
0
votes
1answer
118 views

Creating indexes vs Rebuilding indexes (larger db/log file)

I am a bit lost on what it the right way to do this. I am migrating data from one db to another (corrupt errors) so i did the following: Create a new blank db Generate a object script from my source ...
1
vote
1answer
2k views

How to reclaim database space on Azure SQL Server after setting nvarchar values to null [duplicate]

There is db space challenge at hand on Azure SQL Server database. 490 GB out of 500 GB is used. That's what I read from nice pie chart on Azure portal. Notice that some of the techniques used on-prem ...
-2
votes
1answer
89 views

Disk space problem regarding MongoDB [closed]

I have 12 servers in which there are 4 replicas. The architecture of the mongo servers and the disk spaces are present like: 1st replica s1-rep1 - 287GB s1-rep2 - 0GB s1-rep3 - 0GB 2nd replica ...