1

database on SSD: data only or the DBM program too?

view story
linux-howto

http://serverfault.com – I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s write. Should I reserve that space for the data only, or would it be a good idea to install the operating system (Mac OS X) and the application directory (Adobe Suite, Microsoft Office and the like) on the SSD too? And would it make a substantial speed difference whether I also install the postgresql binaries on the SSD? I have plenty of other space (another 300Gb hard-drive, and a 1Tb one). (HowTos)

u85500's picture
Submitted by u85500 on 09/24/2012

Stories similar to database on SSD: data only or the DBM program too?

SOFA : Open source , user friendly statistical software designed for statistics , data analysis , and reporting .

I have a large Postgres database on Ubuntu 12 (+100GB). I have an old, SATA-based, spinning drive and a new SSD drive. I mainly do data analysis on Postgres (big, ugly select statements). I see a few options:

SSD for data and OS. Spinning for temp space. SSD for data. Spinning for OS and temp space. SSD for OS. Spinning for data and temp space.

I'm thinking that option #2 is the best.

Postgresql Questions 18 weeks 4 days ago

I'm currently running Fedora 17 and am considering running Postgresql as a database server. In looking over the install of postgres I notice that it is installed in /var/lib and the database data is kept there also. Why is the postgres user and the database data not kept somewhere that is not so intergrated into the OS.

I want to do the following,

In my app Android just after to install it, I need to load the SQLite database of this App so that the user may use it.

The data that I need to load my SQLite database are on a SQLServer Database,

I'm thinking in create a web service to connect the SQL Server database and to read the data that I need and pass these data to my Android App to load its SQLite database

I have db server with PostgreSQL 8.4 running on it.

Server has 8G RAM, Intel Core2 Quad CPU Q9300 @ 2.50GHz

At one moment server becomes slow, load average was 20-40. So we bought new ssd disk 160GB and mounted it to /ssd.

I would like to keep two PostgreSQL databases with the same schema, but have one replicated from a master that only keeps a small portion of the live data. The master takes in live data and deletes old data outside of the time window.

PHP Zend with PostgreSQL Issue 29 weeks 5 days ago

I have been developing a web application by using PHP Zend with Database of PostgresSQL in windows XP environment. Apache version 2.2 PostgreSQL version 8.4

Some time, application not retrieve the data from specific table of Database.

Programming is just SELECT data check if exist, then insert.

I have a Cent OS VM instance running on Windows Azure. I have a 1TB data drive mounted to that VM to hold an application's database files. Every week or so at inconsistent intervals, my database crashes and I find that my data drive has been automatically, and without my permission, unmounted.

My data drive still exists with all the data in tact.

Face it, we have a lot of stuff on our hard drives. While some of us still have plenty of free space left thanks to the ever-expanding size of new hard drives, others have all sorts of data which quickly takes up most of their space.