Re: minimum hardware requirements for small postgres db

From: jody <jody(dot)xha(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: minimum hardware requirements for small postgres db
Date: 2013-02-22 13:12:41
Message-ID: CAKbzMGfzwPGVXgQzFn21Ea1zhsAXxsSQB-otizchVLrsK1mxjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

A friend of mine who works mainly on Windows installed a virtual Linux
Machine (i think with VirtualBox) to make use of linux applications.
However, i don't know if postgres would like this...

jody

On Fri, Feb 22, 2013 at 7:13 AM, Paul Smith <paul(dot)smithy987(at)gmail(dot)com> wrote:
> Thanks for your advice. It is very interesting you were able to run pg on a
> SD card in a RasPi ! In addition to Wolgang's last reply, that confirms I
> was misinformed last year when I originally settled on pg as my 1st choice,
> hsqldb being 2nd choice, but then rejected pg in favour of hsqldb, as told
> the former needs stronger hw than I use.
>
> Regarding yours and Gavin's recommendation I change to Linux, I have made
> such an investment in Windows ever since it overlayed DOS, use so many
> Windows dependant programs, it would be a major investment in time to start
> again in Linux.
>
> I have monitored the progress of Linux, particularly Ubuntu over the
> decades, and sadly have always found some reason not to change. I stopped
> using big desktops years ago due to travel needs, and read a big problem
> using Linux on new laptops/nettops was lack of Driver support from
> manufacturers ... causing lots of headaches. Recently, I read the change of
> 'Desktop' to Unity needs maturing. I do realise open-source encourages
> healthy creativity, and so diversity, but just the other week I read
> 'fragmentation' of Linux into so many flavours causes big problems
> supporting Apps.
>
> Another reason your mention of pg on RasPi was so interesting, is I am
> thinking to buy something smaller than a Nettop, to use primarily as a
> media-streamer to TV, but also be a 'backup computer' in case my Nettop
> breaks - as it just has. The choice on ARM hw has to be Linux or the
> Android fork. If ARM, I was thinking of the Tegra3 based OUYA, unless a T4
> or other faster SoC alternative becomes available. So following the news on
> development of Ubuntu for ARM devices with interest.
>
> So as per my last post to Wolfgang, I will install pg once my Nettop
> repaired or replaced.
>
> Thanks, Paul
>
> On 21 February 2013 15:00, Matt Musgrove <MMusgrove(at)efji(dot)com> wrote:
>>
>> 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(at)postgresql(dot)org
>> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Paul Smith
>> Sent: Wednesday, February 20, 2013 7:50 AM
>> To: pgsql-novice(at)postgresql(dot)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.
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Grittner 2013-02-22 13:29:58 Re: PostgreSQL Query Speed Issues
Previous Message Paul Smith 2013-02-22 06:13:24 Re: minimum hardware requirements for small postgres db