* AMIR FRANCO D. JOVEN <amir(at)digi(dot)ph> [061115 12:44]:
> Im new to PostgreSQL.
> My current project uses PostgreSQL 7.3.4.
Ancient. Upgrade it, especially if it's a new database.
> the problem is like this:
> I have a table with 94 fields and a select with only one resultset in only
> one client consumes about 0.86 seconds.
> The client executes three 'select' statements to perform the task which
> consumes 2.58 seconds.
> With only one client this is acceptable, but the real problem is as i add
> more clients, it goes more and more slower.
That depends upon:
a) your table schema.
b) the data in the tables. E.g. how big are rows, how many rows.
c) the size of the result sets.
d) your indexes?
In response to
pgsql-performance by date
|Next:||From: Russell Smith||Date: 2006-11-15 13:31:59|
|Subject: Re: Slow SELECT on three or more clients|
|Previous:||From: AMIR FRANCO D. JOVEN||Date: 2006-11-15 11:37:56|
|Subject: Slow SELECT on three or more clients|