Questions tagged [size]
The size tag has no usage guidance.
0
votes
0answers
33 views
How can I calculate if my row size is greater than one extent [closed]
I have a very large table in SQL Server 2008R2 with a large number of columns. I believe the design of this table may have caused each row to be so large to be using more than one extent to store the ...
0
votes
2answers
18 views
Considerable size difference between mysql versions
We usually employ different MySQL versions for different scenarios. And I realized that similar databases, whith the same amount of tables and data, just because of different mysql versions differs in ...
2
votes
1answer
132 views
Calculating total “on row” bytes for each row … the easy way
We want to calculate the total "on row" storage bytes for each row in the table. As we understand it, we must add up the DATALENGTH() of each column while also accounting for NULLs and things like ...
0
votes
1answer
933 views
Why *not* ERROR: index row size xxxx exceeds maximum 2712 for index “foo”?
We have repeatedly seen failing attempts to index columns with values exceeding a maximum size. Postgres 10 has this kind of error message for it:
ERROR: index row size xxxx exceeds maximum 2712 for ...
1
vote
1answer
63 views
How to know exactly when my Database / Log files grew?
Is there a way to see when (history / log records) of .mdf / .ldf files grew?
Ultimately, is it possible to setup alerting and know immediately when my database / log files grow?
1
vote
1answer
1k views
Reasonable values for thread_cache_size in relation with Connections [closed]
I want to know reasonable values for thread_cache_size in relation with the connections that you have. Which is the good proportion? And which proportions do you handle in relation with your clients ...
2
votes
2answers
376 views
MySQL: optimize column size
I need a tool/command which will check a table then say something like that:
columnA use tinyint instead of int
columnB use enum instead of varchar
I've seen something like this while ago so I do ...
2
votes
0answers
386 views
Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)
sp_spaceused, when executed without any parameters, produces 2 result sets
database_name, database_size, unallocated_size
reserved, data, index_space, unused
Usually when you execute some SP, you ...
0
votes
1answer
97 views
Why is my biggest segment resulting in an empty table?
I'm trying to identify top tables by size in my Oracle DB, I tried with
select segment_type,
segment_name,
sum(bytes/1024/1024) MB
from user_segments s
where segment_type like ...
12
votes
2answers
744 views
Find uncompressed size of all tables in a database
In Dynamics AX there is a caching mechanism where tables can be configured to be loaded into memory and cached. This cache is limited to a certain amount of KB to prevent memory issues. The setting I'...
3
votes
0answers
80 views
Alert on Table size
I need to create an alert on my application table when it reaches 98% of its threshold. I wrote an SP which checks the rows and logs the information into a log file which was monitored by alert system ...
-1
votes
1answer
65 views
varray size can be a variable?
I need to create a varray, and its size must be a parameter of the procedure, for example
create or replace procedure x (cant number)
as
type arreglo is varray(cant) of number;
elarreglo arreglo :=...
0
votes
1answer
293 views
Storing a json string that is 10 kb in size in a SQL Server CE cell
I have a SQL Server CE database in which I have column that takes values of json strings. These json strings are above 9kb as a result of which I am unable to use varchar or char. I guess I could ...
2
votes
2answers
1k views
Microsoft SQL database table size
I have come across a sizing issue with my database tables becoming too large. Some digging has shown that it is how MS SQL stores the information.
I created two test tables and filled them with data:
...
1
vote
4answers
5k views
In Postgres, set log_rotation_size but my logs are still not rotating
I’m using Postgres 9.5 on Ubuntu 14.04. I wanted to rotate my logs whenever they reach a certain size. So I edited /etc/postgresql/9.5/main/postgresql.conf and set this
log_rotation_size = 50MB ...
1
vote
1answer
2k views
How do I limit the size of my Postgres log?
I’m using Postgres 9.5 on Ubuntu 14.04. I notice I’m generating a lot of Postgres logs in
/var/log/postgresql/postgresql-9.5-main.log
. I would like to limit the size of this file, and doing some ...
2
votes
2answers
105 views
SQL Server Database size unchanged after dropping File column
I have a database with a table that has about 10 000 records. One of the columns in this table is a VARBINERY(MAX) that is used to store images. A backup of this database is about 1.2GB. It's size as ...
0
votes
1answer
65 views
Difference in size of table between InnoDB and MEMORY engines
Question
The same table stored on hard drive (InnoDB engine) takes 930.72 MB when in Ram (MEMORY engine) it takes 1538.54 MB.
For what reason?
How to calculate space needed to save data in memory? ...
1
vote
1answer
1k views
Using pg_prewarm to load X number of latest rows into cache
We have a large query that is extra slow when customers "run it the first time, early in the morning..."
So, I found pg_prewarm that I would like to use load into PG's buffer cache
a certain amount ...
-1
votes
2answers
820 views
How can I estimate the size of a new table?
We have tables with a lot of data (50M new rows each month, just in one table).
Now I want to know what would be the impact of adding a new column to those tables, or creating a new table. Something ...
0
votes
1answer
843 views
MySql show content of ibdata1 file, block rising exponentially, why is it growing so fast?
I have a database with most of tables being stored on the InnoDB engine, however an alert raised the other day showing up that the ibdata1 file was growing exponentially.
For what I searched so far, ...
0
votes
1answer
57 views
SQLite function to specify exactly how the data is stored internally
I have used the typeof() function within SQLite before (http://sqlfiddle.com/#!7/fcf0e/1), but I would like to go a little further this time.
I know that INTEGER can be stored internally as 1, 2, 3, ...
5
votes
2answers
14k views
Choosing the right storage block size for sql server
There are many articles on what storage blocks size should be used for sql server e.g. Disk Partition Alignment Best Practices for SQL Server. The right blocks size should improve the performance of a ...
0
votes
1answer
193 views
Log Shipping Disk Sizes
Do the drives that contain the database have to be the exact same size on the primary server as secondary?
I currently have a primary database for OLTP and a standby database used for reporting.
I'm ...
1
vote
1answer
74 views
INDEX size as bytes - PostgreSQL 9.2
Is there any way to get this query to return the index size as BYTES?
SELECT
relid::regclass AS table,
indexrelid::regclass AS index,
pg_size_pretty(pg_relation_size(indexrelid::...
0
votes
1answer
437 views
Schema size [PG TOAST] - PostgreSQL 9.2
I've got the following query to measure the schema's size on my DB:
WITH schema_size AS (
SELECT
tab.table_catalog AS database_name,
tab.table_schema AS schema_name,
tab.table_name,
...
1
vote
0answers
597 views
MongoDB conditional query for array $size
I have a user collection, and each user has different number of id_cards, all id_cards are stored in an array, I can get all users that have 7 id_card by using array $size operator, how do I get the ...
1
vote
1answer
3k views
How to reduce size of PostgreSQL table after dropping columns?
I have a PostgreSQL database. One table is very large. I want to extract a TEXT column into a separate table and see how much I can reduce the size. The problem is that the size appears to stay the ...
0
votes
0answers
114 views
Calculating table size
I'm trying to follow these steps: Space estimation
to estimate the size of my table that I'm creating. I specified an INITIAL as 1M and using the steps above I have the following estimations:
...
0
votes
1answer
77 views
How are limits in mysql on size of columns etc calculated
From the mysql docs,
1 - on joins,
The maximum number of tables that can be referenced in a single join is 61. This also applies to the number of tables that can be referenced in the definition ...
4
votes
1answer
1k views
Why does an sqlite3 .dump and restore result in a smaller database file size?
I have a really naive question about database file sizes. I started out with a 1.2M SQLite database, dumped it to a SQL file, and then restored it to a new database. The restored database file was ...
7
votes
0answers
135 views
How to do Statistics in Partial Indexes of PostgreSQL efficiently? [duplicate]
This answer motivated think again my following tables but I am still uncertain how to store variables/results from data analysis for quick selection in post-processing.
If stored, I think it is well ...
7
votes
1answer
3k views
Estimating the size (of the records) and the overhead in Postgres
Consider the following table in Postgres 9.4:
CREATE TABLE t
(
a1 bigserial,
a2 bigint NOT NULL,
a3 bigint NOT NULL,
a4 integer,
a5 timestamp with time zone NOT NULL,
a6 timestamp with ...
1
vote
1answer
114 views
Database design - load multiple excels daily
My first post ever :) Apologies if I am not so clear with my question - here I go...
I have a design problem from database schema perspective.
My use case is following:
On a daily basis, system ...
1
vote
1answer
7k views
What's the difference between Object.bsonsize and avgObjSize returned by db.collection.stats?
In my collection, my documents seem to be relatively similar. I need to know how much storage I'll need in my production server to store my documents, that's why I queried :
db.collectionName.stats()
...
2
votes
1answer
389 views
Table size is not changed after new column is added
I am trying to check how the table size is going to be increased after adding new column with default values.
I use the following default values: NULL, ''(empty string) and some text(some random text)...
2
votes
1answer
2k views
Need help in increasing maximum table size
Two of the tables vb_post, vb_profilevisitor getting corrupted again and again.
The hosting company suggested the following:
Looks like the problem is that the .MYD table was converted to a .TMD
...
4
votes
2answers
296 views
Adding around 200 rows in a table grows size of the table by 400kb where avg row size is 0.2KB
We are running into an issue where if we look at the avg row size (0.2kb) x number of rows (200) inserted in one of our table, the size should grow by around 40 KB. However the total used space has ...
2
votes
1answer
73 views
Database Size Troubleshooting
I have a SQL Server database and the .MDF file is almost 9GB in size. However, the data and indexes only seem to be taking up a little over 1GB. I've shrunk the database (with and without ...
10
votes
6answers
24k views
Estimate projected database growth
I recently started working with SQL Server 2008 as a DBA trainee. I need calculate the size of the database but also estimate its growth over recent months and the predicted growth for the next 12 ...
4
votes
1answer
999 views
Table Data Space Used Confusion
I have a heap table with around 700k rows. The rowsize is 34 bytes: (1x BIGINT, 2x SMALLINT, 2x BIT, 4X INT, 1x SMALLDATETIME). Why does Data Space Used say this table is taking up nearly 4000000KB (...
-6
votes
1answer
1k views
Postgresql create database with size & resize?
My question regards PostgreSQL database size.
How can I create new database with fixed size? (e.g. 5 GB)
Once I have created fixed sized PostgreSQL database, how can I resize it ?
2
votes
1answer
11k views
Find actual data size from a query?
Is it possible to find the size of data that will be returned by a particular query?
For example, I can use the following to find the number of rows per date:
select mydatecolumn, count(*)
from ...
2
votes
2answers
4k views
how to reduce the size of the datafiles of a oracle DB?
we use a oracle db (11g release2) and the undo tablespase exists of two datafiles and requires 48 GB.
But we just need this size for the boot and the import.
Currently we just use 10 % from the ...
7
votes
2answers
2k views
Why Django session table grows on PostgreSQL
I use PostgreSQL 9.1.6 via PgBouncer 1.4.2 in my Django 1.4.8 project. django_session table grows all the time. VACUUM does not help. VACUUM FULL runs for hours. Only TRUNCATE helps usually.
The ...
0
votes
1answer
374 views
Approximation of table size for MySQL cluster
I want to make some approximation of table size for MySQL cluster.
Please read my reasoning and tell me, if I am right or am I making mistake somewhere.
I have simple table with PK (int) and ...
1
vote
1answer
568 views
Database size not reduced after compressing tables
Using Data Compression, my table size was reduced from 1770 MB to 250 MB, but the database size was not reduced. Why?
18
votes
2answers
18k views
Why doesn't DELETE + REORG free diskspace (DB2)?
In DB2 I have a table containing large binary data. Now i purged the whole table and ran runstats, reorg, runstats, but the amount of disk space taken does not change. What could be wrong here?
The ...
0
votes
2answers
1k views
How to influence Oracle backup output size?
I have two environment one Prod one Dev. Dev is created by Prod data and both have a similar database size. However, the backup output size varies greatly. Prod is about 300 M while Dev always above ...
1
vote
1answer
2k views
Determining the full postgresql size on windows
While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB.
I do not use postgresql myself, I just use a tool that need a ...
