Re: minimum hardware requirements for small postgres db - Mailing list pgsql-novice

From Matt Musgrove
Subject Re: minimum hardware requirements for small postgres db
Date
Msg-id C0FE28B9352B6F4F8CE371643EC3B2515CAAEFD5@EFJDFWMB01.EFJDFW.local
Whole thread Raw
In response to minimum hardware requirements for small postgres db  (Paul Smith <paul.smithy987@gmail.com>)
Responses Re: minimum hardware requirements for small postgres db  (Paul Smith <paul.smithy987@gmail.com>)
List pgsql-novice

I regularly use PostgreSQL on a system with an Atom processor and 4GB of RAM and running CentOS (no problems even on the one box with only 2GB of RAM). I have even tinkered with PostgreSQL on a Raspberry Pi with 256 MB of RAM running off of an 8 GB SD card.

 

I agree with everyone else that moving to Linux will be a wise decision both for security and usability.

 

HTH,

Matt

 

From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Paul Smith
Sent: Wednesday, February 20, 2013 7:50 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] minimum hardware requirements for small postgres db

 

I am having difficulty finding documentation stating the minimum hardware requirements to run pg under Windows. (I did look in the FAQ & User Manual)

 

I seek an open source RDBMS with close adherance to ANSI standards, good free graphic design tools for drawing of the ER Diagram, validation of the ERD model, and generation of the SQL required to build the DB.

 

I only want to design a few small DB Apps using about 20 tables, for single-user offline environment, hopefully runnable on Nettop class hardware under WinXP or Win7 32bit.  

 

I want to access the db via a Forms driven GUI and a Report-writer with features comparable to old versions of Access, but preferably also open-source.

 

 If Atom class nettop not sufficient, would like to know the minimum class of CPU, RAM, GPU required.

 

Thank you in advance for any assistance

This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

pgsql-novice by date:

Previous
From: Gavin Flower
Date:
Subject: Re: minimum hardware requirements for small postgres db
Next
From: Joseph Pravato
Date:
Subject: PostgreSQL Query Speed Issues