X-Original-To: pgsql-performance@postgresql.org Received: from smtp.noos.fr (nan-smtp-06.noos.net [212.198.2.75]) by postgresql.org (Postfix) with ESMTP id D782F474E4F for ; Thu, 20 Mar 2003 16:15:59 -0500 (EST) Received: (qmail 55290743 invoked by uid 0); 20 Mar 2003 21:16:00 -0000 Received: from unknown (HELO camille) ([195.132.173.79]) (envelope-sender ) by 212.198.2.75 (qmail-ldap-1.03) with SMTP for ; 20 Mar 2003 21:16:00 -0000 Message-ID: <00c301c2ef27$65d954a0$4fad84c3@camille> From: "Guillaume Houssay" To: Subject: just to get some opinion on my configuration Date: Thu, 20 Mar 2003 22:26:40 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C0_01C2EF2F.C775E950" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Archive-Number: 200303/140 X-Sequence-Number: 1438 This is a multi-part message in MIME format. ------=_NextPart_000_00C0_01C2EF2F.C775E950 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am setting up a project using APache, PHP and Postgresql. This application will be used by about 30 users. The database is about this type : between 12GB and 15GB 4 tables will have 1M rows and 1000 columns with 90% of INT2 and the rest o= f float (20% of all the data will be 0) the orther tables are less than 10 000 rows Most of the queries will be SELECT being not very complicated (I think at t= his time) I have 1 question regardind the hardware configuration : DELL=20 bi-processor 2.8GHz 4GB RAM 76GB HD using Raid 5 Linux version to be defined (Redhat ?) Do you think this configuration is enough to have good performance after se= tting up properly the database ? Do you thing the big tables should be splitted in order to have less column= s. This could mean that I would have some queries with JOIN ? Thank you for your help ! ------=_NextPart_000_00C0_01C2EF2F.C775E950 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I am setting up a project using APache, PH= P and=20 Postgresql.
This application will be used by about 30= =20 users.
 
The database is about this type :
 
between 12GB and 15GB
4 tables will have 1M rows and 1000 column= s with=20 90% of INT2 and the rest of float (20% of all the data will be 0)
the orther tables are less than 10 000=20 rows
 
Most of the queries will be SELECT being n= ot very=20 complicated (I think at this time)
 
I have 1 question regardind the hardware= =20 configuration :
 
DELL
bi-processor 2.8GHz
4GB RAM
76GB HD using Raid 5
Linux version to be defined (Redhat ?)
 
Do you think this configuration is enough = to have=20 good performance after setting up properly the database ?
 
Do you thing the big tables should be spli= tted in=20 order to have less columns. This could mean that I would have some queries = with=20 JOIN ?
 
Thank you for your help !
 
------=_NextPart_000_00C0_01C2EF2F.C775E950--