New SSD vs performance

[Drainus]

I have a rather technical question, I am considering buying a new SSD disk to expand my database and store it on the disk. Currently I have a smaller SSD disk on which I store my database, also my Win7 is running on it. My question is - if I buy a new SSD drive, will it affect the performance of the database, if it is not going to be on the same disk as Win7? The database is going to be approximately 100GB.

[Flag_Hippo]

The easiest way to do that is backup your existing database(s), uninstall PostgreSQL and then reinstall it to the other drive although you would get the best performance from having only the database on the other drive and PostgreSQL still installed on your Windows drive which you can do by creating a tablespace via PGAdmin.

[Drainus]

Ok, so PostgreSQL should optimally be on the windows drive, but in terms of performance - having the whole database on the other drive should not affect the speed significantly?

[Flag_Hippo]

As long as the other drive is also an SSD then there shouldn't be any noticeable change in performance.