pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
The Last Optimization
2+ messages / 2 participants
[nested] [flat]

* The Last Optimization
@ 2002-09-06 10:51 Areski Belaid <areski5@hotmail.com>
  2002-09-07 05:27 ` Re: The Last Optimization Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: Areski Belaid @ 2002-09-06 10:51 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: The Last Optimization
  2002-09-06 10:51 The Last Optimization Areski Belaid <areski5@hotmail.com>
@ 2002-09-07 05:27 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Christopher Kings-Lynne @ 2002-09-07 05:27 UTC (permalink / raw)
  To: Areski Belaid <areski5@hotmail.com>; +Cc: pgsql-php

You'll have to post your complete schema and the actual queries you are
runing that are so slow.  Postgres can easily handle such large tables, so
there's probably more improvements you can make to the speed.

Chris

On Fri, 6 Sep 2002, Areski Belaid wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-09-07 05:27 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-06 10:51 The Last Optimization Areski Belaid <areski5@hotmail.com>
2002-09-07 05:27 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>

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