PDA

View Full Version : SSD installation and maintenance tips?



Goobertron
09-27-2011, 10:54 AM
I'm about to build a new system with a solid state hard drive and i'm wondering if there any particular things i should do when installing postgres and hem given that SSD space is at a premium.

Also are there any things i can do maintenance wise aside from purging hands and doing a vacuum to keep the HEM and Postgres installations as small as possible as well as keeping my database as small as possible.

Thanks

Sarek
09-27-2011, 12:11 PM
You can find many usefull information about SSD here
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html
this is a big thread, but try to read it

Goobertron
09-28-2011, 01:17 PM
Thanks for getting back to me, i've started ploughing my way through that thread you linked.

I have installed HEM and Postgres on my SSD and am now importing about 1 million hands into a newly created DB. It is currently importing at a speed of about 260 hands p/s. Does that sound about right?

Thanks

Patvs
09-28-2011, 10:39 PM
260 hands/s is really fast.
Do you also have Windows on the SSD?

Re-read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

(editing the postgresql.config file, assigning more RAM to PostgreSQL
also make sure the Firewall / Antivirus program is NOT monitoring the PostgreSQL server)

Goobertron
09-29-2011, 06:39 AM
Yeah OS is on the SSD.

I use the W7 built in firewall and MS Security Essentials. I dont suppose you know how i configure them to leave PostgreSQL alone?

Thanks

Sarek
09-29-2011, 12:06 PM
files to not touch:
postgresql/bin/pg_ctl.exe
postgres.exe

and whole folder
postgresql/data

also c:/hmarchive
and all folders where rooms save histories