Perfomance of postgresql-7.0.3-2

From: Karla Peralta <karlaper(at)elrosado(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Perfomance of postgresql-7.0.3-2
Date: 2000-11-29 16:18:48
Message-ID: 3A252C67.E4FEBACE@elrosado.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Victor 2000-11-29 19:26:15 Weird DB Shutdowns
Previous Message Vladimir Sakhovsky 2000-11-29 14:36:14 ERROR: cannot find attribute 1 of relation pg_temp