Re: minimum hardware requirements for small postgres db

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Paul Smith <paul(dot)smithy987(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: minimum hardware requirements for small postgres db
Date: 2013-02-21 16:06:08
Message-ID: CAL_0b1ukd=FR-YVefddc7WAOUFy5HB9-gjQUNRYLGqvccuU6CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Feb 21, 2013 at 6:10 AM, Paul Smith <paul(dot)smithy987(at)gmail(dot)com> wrote:
> 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 ?

I have not found it in the first message. But probably it was in those
one you mentioned you got 2 replies.

> 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 ?

I would recommend you to try pgAdmin and PostgreSQL Maestro.

> Thanks again. Paul
>
>
> On 21 February 2013 00:53, Sergey Konoplev <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
>> Russia, Moscow +7 901 903 0499
>> Russia, Krasnodar +7 988 888 1979
>>
>> Skype: gray-hemp
>> Jabber: gray(dot)ru(at)gmail(dot)com
>
>

--
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(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Gavin Flower 2013-02-21 17:39:35 Re: minimum hardware requirements for small postgres db
Previous Message Paul Smith 2013-02-21 14:10:10 Re: minimum hardware requirements for small postgres db