X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 52674529D7
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Jul 2005 11:47:46 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 45239-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri,  8 Jul 2005 14:47:36 +0000 (GMT)
Received: from metux.de (seven.metux.de [193.16.1.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 9BD785281A
	for <pgsql-performance@postgresql.org>;
	Fri,  8 Jul 2005 11:47:34 -0300 (ADT)
Received: (from weigelt@localhost)
	by metux.de (8.12.10/8.12.10) id j68DkdWK008133
	for pgsql-performance@postgresql.org; Fri, 8 Jul 2005 15:46:39 +0200
Date: Fri, 8 Jul 2005 15:46:39 +0200
From: Enrico Weigelt <weigelt@metux.de>
To: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: plain inserts and deletes very slow
Message-ID: <20050708134638.GA6368@nibiru.borg.metux.de>
Reply-To: weigelt@metux.de
Mail-Followup-To: postgresql performance list
	<pgsql-performance@postgresql.org>
References: <42C8B23F.4000400@telogis.com>
	<20050704085903.GG9777@nibiru.borg.metux.de>
	<42C9C7E278.E5BFKG@129.180.47.120>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42C9C7E278.E5BFKG@129.180.47.120>
User-Agent: Mutt/1.4.1i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200507/84
X-Sequence-Number: 13325

* Klint Gore <kg@kgb.une.edu.au> wrote:

<snip>

> Turn on statement logging.  I've seen delphi interfaces do extra queries
> on system tables to find some structure information.

I'm already using statement logging of all queries taking longer
than 200ms. It seems that only the INSERT takes such a time. 

The client is in fact written in delphi, and it sometimes seems 
to do strange things. For example we had the effect, that some
new fields in some table were regularily NULL'ed. None of the 
triggers and rules inside the DB could do that (since there's 
no dynamic query stuff) and the delphi application is the only 
one writing directly to this table.


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------