Re: minimum hardware requirements for small postgres db

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(dot)ru(at)gmail(dot)com
> <mailto:gray(dot)ru(at)gmail(dot)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 <tel:%2B1%20415%20867%209984>
> Russia, Moscow +7 901 903 0499 <tel:%2B7%20901%20903%200499>
> Russia, Krasnodar +7 988 888 1979 <tel:%2B7%20988%20888%201979>
>
> Skype: gray-hemp
> Jabber: gray(dot)ru(at)gmail(dot)com <mailto:gray(dot)ru(at)gmail(dot)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