new PC postgres query

[MoniesRemovalPLC]

i looked through your FAQ on Postgres updating but didnt see a link to a fresh first time install for the latest version of Postgres, sry if i missed it can you point me in the right direction, i have latest windows 64 bit and dual SSDs so should be able to run PT3 pretty damn quick now (will report on my findings in the "making PT3 fly" thread :)

[WhiteRider]

You can get the installer from this page. Get the 64-bit version 9 for optimum performance, and enjoy your new machine! It'll be interesting to see what the performance is like. :)

[MoniesRemovalPLC]

oh yh thx i found the postgres download page and i got version 9.0, now i have a few noob
questions:

* i have a 60GB SSD to run windows, and a 120GB SSD to run my database, which of these drives is it best to install postgres on, and PT3 on ?

[WhiteRider]

For absolute optimum performance it is best to have the PostgreSQL databases on a drive on their own, so that database access isn't interrupted by any other disk activity. There is a tutorial about setting this up linked from the Database / PostgreSQL FAQ.
For a system like yours I suspect that the additional setup may not be worth it - if you install PostgreSQL on a drive on its own (the databases will be stored there too by default) then that should be pretty fast. Please bear in mind I don't have direct experience with setting up systems like this so you may get better advice - Kraada will be on later and may have more to say on the matter too.

[MoniesRemovalPLC]

K thx man, i should have mentioned i have a 60GB for running windows, a 120GB that was planned for me database running, and also a 1TB normal hard drive for all other stuff, the guy who made the system assured me it d fly after i forwared him some of the testing published in these forums

[WhiteRider]

I'm sure it will!

[MoniesRemovalPLC]

so if i have a completely dedicated 120GB SSD for PT3 / postgres that should provide me with the fastest performance? so its best to install both components on that drive? is that correct?

[tarix]

so if i have a completely dedicated 120GB SSD for PT3 / postgres that should provide me with the fastest performance? so its best to install both components on that drive? is that correct?

No. Install PT3 and your Poker clients on your 60GB drive and install only Postgres on your 120GB drive.

[MoniesRemovalPLC]

thanks for the advice - can i ask if its possible to install postgres 9 on my seperate drive using the PT3 easy installer - which installs postgres and PT3 all in one install when you run the PT3 installer exe file???

[kraada]

Yes that should work just fine.