Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A06FE476E4F for ; Fri, 6 Sep 2002 06:51:23 -0400 (EDT) Received: from hotmail.com (oe21.law4.hotmail.com [216.33.148.125]) by postgresql.org (Postfix) with ESMTP id 0BE20476E4D for ; Fri, 6 Sep 2002 06:51:23 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 6 Sep 2002 03:51:25 -0700 X-Originating-IP: [212.9.66.13] From: "Areski Belaid" To: References: <3CCE936B.245D870C@juliana-multimedia.com> <1022941995.3cf8db2b32686@webmail.acucore.com> <200208021316.45445.chrup@earthlink.net> Subject: The Last Optimization Date: Fri, 6 Sep 2002 12:51:27 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: X-OriginalArrivalTime: 06 Sep 2002 10:51:25.0811 (UTC) FILETIME=[58CBF430:01C25593] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/19 X-Sequence-Number: 1474 I have a huge table with 14 field and few million of data... My application Php/Pg start to be impossible to use. Redhat 7.3 Dual PIII 900Mhz System 2GB RAM I did already a some optimization optimization : max_connections = 64 shared_buffers = 32000 sort_mem = 64336 fsync = false --- echo 128000000 > /proc/sys/kernel/shmmax also Vaccum,analyze and Index --- This optimization was enough at the beginning but NOT now with some million of instance. So WHAT I CAN DO ??? USE ORACLE ??? I Think maybe to split my mean table to different table Mean_a Mean_b ... Mean_z ??? IF it's the way someone where I can find doc or help about howto split table ??? I M lost !!! ;) Areski