From: | Thomas Wong <twong(at)aamsin(dot)com> |
---|---|
To: | Karla Peralta <karlaper(at)elrosado(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Perfomance of postgresql-7.0.3-2 |
Date: | 2000-11-30 01:07:05 |
Message-ID: | 3A25A839.453F0BFF@aamsin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
Maybe use less columns/table if possible. It is possible the client to
share the load with the server ? Some processing can still be done by
the client. Btw, do you measure the system performance (disk access, cpu
load, bla bla bla on the OS). I tried using "hdparm" to increase my disk
access speed on my server and it's help.
hopefully this suggestion will help..
Regards,
Thomas wong
Karla Peralta wrote:
>
>
> Hi,
>
> I have some problems with the perfomance when I run my program
> and I'm just testing in two machines.
>
> I have a diskless system.
>
> This is what I have:
>
> System Configuration:
>
> Server
>
> Architecture : Pentium II
> Memory : 64Mb
> Operating System : RedHat 6.2
> PostgreSQL version : 7.0.3-2
> Compiler used : FlagShip-4.48-7451
> Others : FS2tools-4.48-7451
> SQLkit_PG-1.00
>
>
> Client - Diskless
>
> Memory : 16Mb
> Architecture : Pentium
> Printer : TM930 Paralell Port
>
> My database is 268 Mb, 60 tables, the largest table has about 181659
> rows and 46 columns. I'm using index in each table.
>
> When the program is running it stop for about 15 seconds and then
> continues. I'd like to know what can I do for a better perfomance
> because I need 40 clients machines.
>
> Tell me if you need more information.
>
> Regards,
>
> Karla
From | Date | Subject | |
---|---|---|---|
Next Message | hamptone | 2000-11-30 08:08:20 | Re: Redundant databases/real-time backup |
Previous Message | Victor | 2000-11-29 19:26:15 | Weird DB Shutdowns |