New answers tagged

0 votes

Could MySQL perform better on a 10GB network storage with raid vs local HDD?

A Hardware RAID controller with Battery Backed Write Cache makes nearly all writes take essentially zero time. If your app is reporting on Data Warehouse data, the I/O decreases dramatically if you ...
user avatar
  • 68.1k
1 vote

Could MySQL perform better on a 10GB network storage with raid vs local HDD?

You won’t get close to SSD speeds no matter how you set up HDDs (well, unless you give them a cache). That said, the impact on your application performance is going to be against your IO time only. If ...
user avatar
  • 2,324
0 votes
Accepted

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

After running VACUUM FULL public.region; and VACUUM FULL public.region2;, test again with: SELECT pg_relation_size('public.region'); Three possible issues: The obvious reason: table bloat from ...
user avatar
0 votes

Which Oracle datafiles grow in size?

If you don't want files to grow on an SSD, then the easiest solution is to not put the database on SSD. You should expect everything under $ORACLE_BASE to grow in size. (This is 99%+ of the database) ...
user avatar
  • 4,708

Top 50 recent answers are included