Re: I need minimum specs for running PostgreSQL - Mailing list pgsql-general

From Wm. G. Urquhart
Subject Re: I need minimum specs for running PostgreSQL
Date
Msg-id Pine.LNX.4.44.0205221440260.5109-100000@mailer.wurquhart.co.uk
Whole thread Raw
In response to I need minimum specs for running PostgreSQL  (David.Lofstrand@surgical-science.com)
List pgsql-general
On Wed, 22 May 2002, David.Lofstrand@surgical-science.com wrote:

> Hello,
>
> Does anybody have some kind of minimum specs for running the PostgreSQL on
> a PC-server (cygwin)?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Hi,

The thing with this kind of question is there are min specs and min specs,
since there are so many variable to take into consideration. Data load,
concurrency, usage (select -v- update / insert), indicies used,
structuring of query etc.

I'd be bold to say you'd get respectable performance from a Pentium PII
with 256K Ram on Unix. But Windows is well Windoze. I think you'd be
looking at a 500Mhz x 512Mb at min. But this is my opinion others will no
doubt tell a different story.

It's not much I know but you really need to provide a bit more information
as to the intentions of the server before you can realistically expect to
get a real life idea of hardware requirements.

Do you have this information?

--
Regards,


Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk



pgsql-general by date:

Previous
From: Tom Jenkins
Date:
Subject: Re: Update and Insert in a View Insert Rule
Next
From: Tom Lane
Date:
Subject: Re: psql -l gives bad output