esql.orgSubject: Re: [GENERAL] DELETE performance
issues
On Thu, 2006-11-02 at 11:27 -0500, Tom Lane wrote:
Are you absolutely sure about
that last? Unindexed foreign keyreferences are the explanation nine times out of ten when
someonecomplains about deletes being
slow. This was
certainly
On Thu, 2006-11-02 at 11:27 -0500, Tom Lane wrote:
Are you absolutely sure about that last? Unindexed foreign key
references are the explanation nine times out of ten when someone
complains about deletes being slow.
This was certainly the major cause when I had slow deletes. (T
"Schwenker, Stephen" <[EMAIL PROTECTED]> writes:
> All the tables have primary keys and when I explain the queries, they
> use the primary key index. I have increased the shared memory which
> only seems to help when the same table is accessed synchronously but
> this switching back and forth betw
general@postgresql.org
Subject: Re: [GENERAL] DELETE performance issues
On Fri, Oct 27, 2006 at 03:40:51PM -0400, Schwenker, Stephen wrote:
> I'm having a performance issue with postgresql. I'm using it with
> JBoss BPM api and when I use the api to delete a process instance
On Fri, Oct 27, 2006 at 03:40:51PM -0400, Schwenker, Stephen wrote:
> I'm having a performance issue with postgresql. I'm using it with JBoss
> BPM api and when I use the api to delete a process instance from the
> database, it seems like the delete requests are taking quite a long time
> to delet
Hello,
I'm having a performance issue with
postgresql. I'm using it with JBoss BPM api and when I use the api to
delete a process instance from the database, it seems like the delete requests
are taking quite a long time to delete. I've also noticed that when I
execute the delete, the c
