Re: Perfomance of postgresql-7.0.3-2

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