pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp: System requirements for postgresql 7.4.1
3+ messages / 3 participants
[nested] [flat]
* Help: System requirements for postgresql 7.4.1
@ 2004-01-29 15:29 Juan Carlos Diez <jdiez@eluniversal.com>
2004-01-29 23:36 ` Re: Help: System requirements for postgresql 7.4.1 Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-01-30 08:07 ` Re: Help: System requirements for postgresql 7.4.1 Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
0 siblings, 2 replies; 3+ messages in thread
From: Juan Carlos Diez @ 2004-01-29 15:29 UTC (permalink / raw)
To: pgsql-admin
Hello, I'm evaluating that version and I can't find system requirements for it. Could anybody please help me with these questions?
1.1. Hardware:
1.1.1. C.P.U. (how many processors, what speed)
1.1.2. Ram. (minimum and desired)
1.1.3. Disk.
1.1.4. Networking.
1.1.5. Scalability
1.2. Software:
1.2.1. OS. (wich versions and patches are required for linux and solaris)
1.2.2. Required software packages.
Thank you very much.
Best regards,
JCD.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Help: System requirements for postgresql 7.4.1
2004-01-29 15:29 Help: System requirements for postgresql 7.4.1 Juan Carlos Diez <jdiez@eluniversal.com>
@ 2004-01-29 23:36 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
1 sibling, 0 replies; 3+ messages in thread
From: Sam Barnett-Cormack @ 2004-01-29 23:36 UTC (permalink / raw)
To: Juan Carlos Diez <jdiez@eluniversal.com>; +Cc: pgsql-admin
The short answer is, you can run it on just about anything any system
that will run an OS it will run under.
How well it will perform depends on your system and what you're trying
to do with it.
On Thu, 29 Jan 2004, Juan Carlos Diez wrote:
> Hello, I'm evaluating that version and I can't find system requirements for it. Could anybody please help me with these questions?
>
> 1.1. Hardware:
> 1.1.1. C.P.U. (how many processors, what speed)
> 1.1.2. Ram. (minimum and desired)
> 1.1.3. Disk.
> 1.1.4. Networking.
> 1.1.5. Scalability
>
> 1.2. Software:
> 1.2.1. OS. (wich versions and patches are required for linux and solaris)
> 1.2.2. Required software packages.
>
> Thank you very much.
>
> Best regards,
>
> JCD.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Help: System requirements for postgresql 7.4.1
2004-01-29 15:29 Help: System requirements for postgresql 7.4.1 Juan Carlos Diez <jdiez@eluniversal.com>
@ 2004-01-30 08:07 ` Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
1 sibling, 0 replies; 3+ messages in thread
From: Thierry Missimilly @ 2004-01-30 08:07 UTC (permalink / raw)
To: Juan Carlos Diez <jdiez@eluniversal.com>; +Cc: pgsql-admin
Hi,
In fact it is difficult to answer to that questions as they depend of how big is your database, how many simultaneous connections you
have, ... etc
But, I can help you by giving you my results on a Bi-CPU Xeon 2.6 GHz , 4 Gb RAM, external 2 x RAID0 on four disks each with Redhat
9.0.
1) Connections : This system support easily 500 simultaneous connections. The performances decrease only by 11 % between 100 users and
500 users.
2) Database size : This is a bit more complex. If your database size is 700 Mb (less << RAM size) the performances are very good. But
when the database size is bigger than the RAM size, the I/O increased rapidly and your system spend time in Wait I/O state. For
example, I have noted that from 700 Mb to 7 Gb the performances drop by 65% on my 4 GB memory machine. That' s don't means they are
bad but that means that if you want to improve performances on very big Database you should have to spend money to increase the I/O
throughput instead of bought more CPUs.
Please note that this remarks is valid on other RDBMS, even on commercial RDBMS.
Please note too, that there is about 30 % of performance gain between SCSI internal disks and an external RAID0 Chaparral LUN.
About the software, I have preferred to install my own downloaded Postgres 7.4 version as the Database Redhat package is a less recent
Postgres version (7.2 or 7.3) and a lot of things have been improved in the 7.4. Further more, I prefer to install all Postgres bin
and lib in /usr/local/pgsql than in /usr/bin and /usr/lib.
Thierry Missimilly
Juan Carlos Diez wrote:
> Hello, I'm evaluating that version and I can't find system requirements for it. Could anybody please help me with these questions?
>
> 1.1. Hardware:
> 1.1.1. C.P.U. (how many processors, what speed)
> 1.1.2. Ram. (minimum and desired)
> 1.1.3. Disk.
> 1.1.4. Networking.
> 1.1.5. Scalability
>
> 1.2. Software:
> 1.2.1. OS. (wich versions and patches are required for linux and solaris)
> 1.2.2. Required software packages.
>
> Thank you very much.
>
> Best regards,
>
> JCD.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Attachments:
THIERRY.MISSIMILLY.vcf (text/x-vcard, 358B) download
begin:vcard
n:Missimilly;Thierry
tel;fax:+33 (0)4 76 29 78 78
tel;work:+33 (0)4 76 29 74 54
x-mozilla-html:FALSE
url:http:\\www.bull.com
org:Bull Research & Developpement OpenSource
adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE
version:2.1
email;internet:Thierry.Missimilly@bull.net
x-mozilla-cpt:;24696
fn:Thierry Missimilly
end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-01-30 08:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-29 15:29 Help: System requirements for postgresql 7.4.1 Juan Carlos Diez <jdiez@eluniversal.com>
2004-01-29 23:36 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
2004-01-30 08:07 ` Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox