How does running PostgreSQL on a Windows desktop with pgAdmin III compare to running it on a dedicated server? I am trying to develop a database with very large tables (~60 million rows) with the following hardware:
- 64-bit Windows 7
- Dual quad-core Intel Core i7-4770 CPU @ 3.40 GHz
- 32 GB RAM
I would like to know if it would be worthwhile to invest in a server or whether the desktop should be sufficient. The tables will be static, so I mainly concerned with the time it will take to read the data and perform basic aggregate and join operations.