Skip site navigation (1) Skip section navigation (2)

Re: Slow SELECT on three or more clients

From: Andreas Kostyrka <andreas(at)kostyrka(dot)org>
To: "AMIR FRANCO D(dot) JOVEN" <amir(at)digi(dot)ph>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow SELECT on three or more clients
Date: 2006-11-15 13:29:09
Message-ID: 20061115132909.GA22673@andi-lap.la.revver.com (view raw or flat)
Thread:
Lists: pgsql-performance
* AMIR FRANCO D. JOVEN <amir(at)digi(dot)ph> [061115 12:44]:
> Hi!
> 
> 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?

Andreas

In response to

pgsql-performance by date

Next:From: Russell SmithDate: 2006-11-15 13:31:59
Subject: Re: Slow SELECT on three or more clients
Previous:From: AMIR FRANCO D. JOVENDate: 2006-11-15 11:37:56
Subject: Slow SELECT on three or more clients

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group