PostgreSQL 9.3 - Database HUGE
Posted: Sun Jan 19, 2014 9:08 am
Hi,
I updated my PostgreSQL to the latest 9.3 version. I created a new database and manually imported hands from 9 days of datamining (HHDealer).
In the middle of the manual import (about 1.2M Hands), the velocity basically stops. When a look at the size of the data folder on the Postgresql folder it is about 200GB!!!!
My computer is a Dell Studio 1747, 4GB ram, 450GB HD, Core i7. I just bought another 4Gb Ram, and a 120 SSD drive, but before I upgrade it, I want to fix this (because of the size of the SSD).
Does anyone know how to fix this?
Sorry I`m very noob on programimg or even with the software operations.
Thanks!
I updated my PostgreSQL to the latest 9.3 version. I created a new database and manually imported hands from 9 days of datamining (HHDealer).
In the middle of the manual import (about 1.2M Hands), the velocity basically stops. When a look at the size of the data folder on the Postgresql folder it is about 200GB!!!!
My computer is a Dell Studio 1747, 4GB ram, 450GB HD, Core i7. I just bought another 4Gb Ram, and a 120 SSD drive, but before I upgrade it, I want to fix this (because of the size of the SSD).
Does anyone know how to fix this?
Sorry I`m very noob on programimg or even with the software operations.
Thanks!