The Last Optimization

Поиск
Список
Период
Сортировка
От Areski Belaid
Тема The Last Optimization
Дата
Msg-id OE21YFkuutSgcOrBLSA00010b69@hotmail.com
обсуждение исходный текст
Ответ на Pb with the French accentuated characters  (frederic massot <frederic@juliana-multimedia.com>)
Ответы Re: The Last Optimization  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-php
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

В списке pgsql-php по дате отправления:

Предыдущее
От: Harry Waddell
Дата:
Сообщение: Re: transactions?
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: The Last Optimization