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 78F3152892 for ; Mon, 4 Jul 2005 00:51:51 -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 08543-09 for ; Mon, 4 Jul 2005 03:51:41 +0000 (GMT) Received: from smtp008.bizmail.sc5.yahoo.com (smtp008.bizmail.sc5.yahoo.com [66.163.170.74]) by svr1.postgresql.org (Postfix) with SMTP id D7A8D52896 for ; Mon, 4 Jul 2005 00:51:36 -0300 (ADT) Received: (qmail 62853 invoked from network); 4 Jul 2005 03:51:35 -0000 Received: from unknown (HELO ?192.168.3.41?) (david.mitchell@telogis.com@203.98.10.169 with plain) by smtp008.bizmail.sc5.yahoo.com with SMTP; 4 Jul 2005 03:51:35 -0000 Message-ID: <42C8B23F.4000400@telogis.com> Date: Mon, 04 Jul 2005 15:51:27 +1200 From: David Mitchell User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: weigelt@metux.de Cc: postgresql performance list Subject: Re: plain inserts and deletes very slow References: <20050703224537.GA9777@nibiru.borg.metux.de> <20050703225707.GB9777@nibiru.borg.metux.de> <42C887DC.40308@telogis.com> <20050704000157.GD9777@nibiru.borg.metux.de> <42C88D17.4080004@telogis.com> <20050704001747.GE9777@nibiru.borg.metux.de> In-Reply-To: <20050704001747.GE9777@nibiru.borg.metux.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200507/27 X-Sequence-Number: 13268 Hmm, you said you don't experience this when executing the query manually. What adapter are you using to access postgres from your application? libpq, npgsql or something else? And what is your method for running the query 'manually'. Are you running it locally or from a remote machine or what? Regards David Enrico Weigelt wrote: > * David Mitchell wrote: > >>Perhaps if you are doing a lot of inserts and deletes, vacuuming every 6 >>minutes would be closer to your mark. Try vacuuming every 15 minutes for >>a start and see how that affects things (you will have to do a vacuum >>full to get the tables back into shape after them slowing down as they >>have). > > > hmm. I've just done vacuum full at the moment on these tables, but it > doesnt seem to change anything :( > > > cu -- David Mitchell Software Engineer Telogis