Re: Delete performance

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Jarrod Chesney <jarrod(dot)chesney(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete performance
Date: 2011-05-31 09:26:59
Message-ID: BANLkTi=WgBjTmUvC=8-hdCAQwZA4Mz_qHg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

9.0rc1 ?
You know that the stable 9.0 has been out for quite a while now.
Its not going to affect the delete speed in any way, but I would
generally advice you to upgrade it to the lates 9.0.x

As for the delete it self, check if you have indices on the tables
that refer the main table on the referred column. Often times that's
the issue.
Other thing is , number of triggers on the other tables.

--
GJ

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2011-05-31 13:57:43 Re: The shared buffers challenge
Previous Message Jenish 2011-05-31 07:20:59 Strange behavior of child table.