pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Areski Belaid <areski5@hotmail.com>
To: pgsql-php@postgresql.org
Subject: The Last Optimization
Date: Fri, 6 Sep 2002 12:51:27 +0200
Message-ID: <OE21YFkuutSgcOrBLSA00010b69@hotmail.com> (raw)
References: <3CCE936B.245D870C@juliana-multimedia.com>
	<1022941995.3cf8db2b32686@webmail.acucore.com>
	<OE76IVwEBblN7eNYhaS0000ba07@hotmail.com>
	<200208021316.45445.chrup@earthlink.net>

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



view thread (2+ messages)  latest in thread

Message-ID: <OE21YFkuutSgcOrBLSA00010b69@hotmail.com>
Permalink:  ../OE21YFkuutSgcOrBLSA00010b69@hotmail.com/
Also on:    postgresql.org/message-id/OE21YFkuutSgcOrBLSA00010b69@hotmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: areski5@hotmail.com
  Subject: Re: The Last Optimization
  In-Reply-To: <OE21YFkuutSgcOrBLSA00010b69@hotmail.com>
  References: <3CCE936B.245D870C@juliana-multimedia.com> <1022941995.3cf8db2b32686@webmail.acucore.com> <OE76IVwEBblN7eNYhaS0000ba07@hotmail.com> <200208021316.45445.chrup@earthlink.net> <OE21YFkuutSgcOrBLSA00010b69@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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