On 22/02/13 03:10, Paul Smith wrote:
Thanks for your input on minimum hardware requirements for small postgres db.
You say a modern Nettop is more than enough recommending a minimum RAM of 256MB. My original post did say under Windows. As 256MB is not enough to even run Windows, did you miss that ?
It also seems at least some ERD design tools require strong hardware 2GHz, 4GB RAM. Have you any recommendations on choice of an ERD design tool as per prev. post ?
Thanks again. Paul
On 21 February 2013 00:53, Sergey Konoplev
<gray.ru@gmail.com> wrote:
> It is for the above reasons I am revisiting the suitability of pg. As stated my DB App will be single user offline use, small, about 20 tables, and many of those will be just short 'picklists' triggered by Form input for easier-validated dataentry. I notice the FAQ, User Manual, & neither of the 2 replies directly addresses my primary question: "If Atom class nettop not sufficient, would like to know the minimum class of CPU, RAM, GPU required." Is it quite difficult to make even a rough recommendation of minimum hardware for the above 'small' db ?
For single user personal use small database any modern (down to 5
years old) nettop will be more than enough. I would recommend 256MB as
the bottom limit of RAM. See also this link
http://www.postgresql.org/docs/9.2/static/supported-platforms.html.
--
Sergey Konoplev
Database and Software Architect
http://www.linkedin.com/in/grayhemp
Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com
I would suggest upgrading to a Linux distribution if you can. Though I know there may be many reasons why it is not practicable for you, but ...
Linux is more secure, usually faster, and a lot easier to use. I have used both Linux and various Microsoft Operating Systems.
Cheers,
Gavin