PostgreSQL on Desktop vs. Server

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.

Replay

Category: postgresql Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.220 (s). 12 q(s)