The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
584 views

TempDB MDF file huge after update script ran

On the weekend we had a huge deployment run that affected a large chunk of our system. It was all run in one massive transaction (probably the wrong thing to do). As a result our TempDB DatabaseFile ...
1
vote
0answers
40 views

Multiple databases with medium tables or Single database with huge tables

I've developed a shop management software using Postgresql and JAVA. I would like to know which of the solutions below is the best one for my specific situation: Only one database with huge tables ...
0
votes
0answers
17 views

Understanding SQLite filesize, size “always” 1.471.488 bytes

We store some Data in a zipped SQLite file. Basically it's 7 tables, 6 of fixed size and one table varies. The table has only 3 fields, which contain the date and 2 small integers. Example: ...
0
votes
0answers
62 views

How large should a database table grow?

I have been experiencing some very slow queries for a specific table. This table grows daily. I ran the pg_relation_size function, which gives the size of a table in the database: mydb=# select ...
0
votes
0answers
29 views

How to avoid hitting the memory ceiling with temporary table?

I running a MySql DB at a webhosting company. The size limit of a schema/DB is set to 100Mb. I'm using temporary tables in my query like: CREATE TEMPORARY TABLE t_foo SELECT * FROM Foo INNER JOIN ...