Solid state drive

[PokerBot]

I am thinking of buying a SSD drive for my windows 7 and for SQL; i have read differing views on them when it comes to SQL; would they be much faster than my 150GB velociraptor? Also i heard that you dont have to cluster databases if they are on a SSD; is this true; because i will only be getting a small one 60GB so it will be basically full all the time; thus would not be able to cluster effiently. Would the performance decrease if they drive is alwasy full to the degree that it would make buying one pointless?

These are my picks; please add more if you can reccomend some. Note i need it to be reilable; regarding the controller, i heard some SSD disapear from bios! I dont want the hassle of buying anotehr raptor and rading them but would would do better and how much by?

OCZ Vertex 2E 60GB

Corsair Reactor 60GB

Crucial RealSSD C300 64GB

[WhiteRider]

I don't know much about SSD drives myself, so I won't offer any definitive answers. I have seen other people say that you don't need to cluster too, but I would expect that clustering would still help somewhat as it isn't quite the same as defragmenting - I might be wrong, though.

[kraada]

Clustering reorders the data in the files so as to make them quicker to read - since the main benefit of an SSD is the extremely small amount of time required to find random data on the hard drive, the amount of time required to cluster will likely outweigh any benefit from clustering.

Honestly what setup you want is going to vary depending on your usage profile. How large of a database are you expecting to build? If it's only your own play and you play maybe 10,000 hands a month space won't be a problem for you for a while.

I'd strongly recommend putting your operating system and most used programs on the SSD - that will also give you lots of other benefits when using your computer. I don't have one set up myself, but my understanding is that the speed improvement is quite significant. Unfortunately since I haven't invested in one of these drives myself I don't know what brand is going to be best. I did skim a report recently about SSD value/performance that you can find here; I'm not 100% sure how useful it'll be to you but it can't hurt, right? :)

[PokerBot]

I ended up going for the vertex 2 60GB; i should get it tomorrow Just wondering; can i simply install postgre on my d:/ which will be my velociraptor to see the performance gains mentioned regarding the "tuning two hard drives" thread or do i have to do the whole table space thing. For the former method would that mean if i reinstalled winodws would postgre still work with the new install?

Also i have not got a reply yet regarding my HUD stats from observed hands having way off 3/4betting stats; please look into this

thanks

[WhiteRider]

Yes, if you install PostgreSQL on D: then your databases will be stored on D: too.

Also i have not got a reply yet regarding my HUD stats from observed hands having way off 3/4betting stats; please look into this

Where did you ask about that?
Are these hands bought iPoker hands? If so, they probably have unrealistic stack sizes which are too big for PT3 to import and that causes the 3- / 4-bet problem.
If you do a global replace of 10000000 with 100000 then the import will work fine.

[okayplayer]

I installed a Vertex 120GB SSD on my new build last yr, and it is sick quick.

[clcheapshoes520]

I installed a Vertex 120GB SSD on my new build last yr, and it is sick quick.

is it true :heart:

[PokerBot]

But if i simply install postgres on d: on the raptor will i see the performance gains from the fine tuning two hard drives; or do i have to do the table space thing in order to see more gains? If so how much of a gain can i expect to see by doing table space on the raptor compared to simply installing the whole postgre on d? And should i still keep poker tracker and my poker software on C to remove bottlenecks etc? Thanks

[kraada]

If you just put the entire database on the separate drive you don't get the benefit from having data and logs split up - you need a tablespace for that. However, you do get some benefits from not having your database on the drive your operating system is using. I don't have a detailed estimate for how much those gains are though.

[zubs1aa]

But if i simply install postgres on d: on the raptor will i see the performance gains from the fine tuning two hard drives; or do i have to do the table space thing in order to see more gains? If so how much of a gain can i expect to see by doing table space on the raptor compared to simply installing the whole postgre on d? And should i still keep poker tracker and my poker software on C to remove bottlenecks etc? Thanks

pokerbot.. much more detailed response follows. However you neeed to provide soem details to hwlp people help you:

What is the current setup? How many drives/ what types/ what is on those drives? (And particularly current location of PT and of postgre/teh PT DB)

Also, you are not real clear about your proposed plan. What is the proposed new configuration? It looks like the velociraptor is your D drive, but it isn't clear whether you are replacing your c: drive with the SSD.. or adding the SSD as a third drive. Detailing this plan (with - again, specifics as to which apps go where, where the OS is and where postgre/DB and the PT app will go....) is something we needt osee to help ya out