pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Radlowski <adamr@informatyka.gdansk.pl>
To: MG <pgsql-admin@carladata.de>
To: pgsql-admin@postgresql.org
Subject: Re: sql-statement blocks maschine
Date: Tue, 23 May 2006 13:45:53 +0200
Message-ID: <4472F5F1.1090803@informatyka.gdansk.pl> (raw)
In-Reply-To: <001301c67e44$6526df00$340aa8c0@geisslinger>
References: <001301c67e44$6526df00$340aa8c0@geisslinger>

Run the "top" program. You'll see, that Your server CPU time is strongly 
take by postmaster. The best way is to have two machines - servers: for 
database server and for terminals. Maybe good will be to have more than 
one CPU in the one server and run database server on CPU not used by 
others apps.
Greetins
Adam

MG wrote:

> Hello,
>  
> we are using PostgreSQL 8.0.3 under SuSE Linux 9.2 and SCO OpenServer 
> 6.0 and have some perfomance problems. We are working with 
> telnet-clients, which controlls our application on the server. The 
> application does the sql-statements
>  
> If we have sql-statements e.g. SELECT or UPDATE which takes some 
> minutes to be executed, then this statement blocks the whole maschine. 
> This has the affect, that the telnet-clients work very very slowly, 
> e.g. it takes several seconds from one keystroke to the next one. So 
> you can`t work with the application in a reasonable way.
>  
> These sql-statments are so variable, that we can`t create a index for 
> each combination.
>  
> How can we solve that problem?
>  
> Greeting
> Michaela





view thread (2+ messages)

Message-ID: <4472F5F1.1090803@informatyka.gdansk.pl>
Permalink:  ../4472F5F1.1090803@informatyka.gdansk.pl/
Also on:    postgresql.org/message-id/4472F5F1.1090803@informatyka.gdansk.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: adamr@informatyka.gdansk.pl, pgsql-admin@carladata.de
  Subject: Re: sql-statement blocks maschine
  In-Reply-To: <4472F5F1.1090803@informatyka.gdansk.pl>
  References: <001301c67e44$6526df00$340aa8c0@geisslinger> <4472F5F1.1090803@informatyka.gdansk.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox