pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedThe Last Optimization
2+ messages / 2 participants
[nested] [flat]
* The Last Optimization
@ 2002-09-06 10:51 Areski Belaid <areski5@hotmail.com>
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-07 05:27 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Areski Belaid <areski5@hotmail.com>
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