From: David Mitchell <david.mitchell@telogis.com>
To: weigelt@metux.de
Cc: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: plain inserts and deletes very slow
Date: Mon, 04 Jul 2005 15:51:27 +1200
Message-ID: <42C8B23F.4000400@telogis.com> (raw)
In-Reply-To: <20050704001747.GE9777@nibiru.borg.metux.de>
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>
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 <david.mitchell@telogis.com> 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
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: david.mitchell@telogis.com, weigelt@metux.de
Subject: Re: plain inserts and deletes very slow
In-Reply-To: <42C8B23F.4000400@telogis.com>
* 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