Re: Delete performance - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Delete performance
Date
Msg-id BANLkTi=WgBjTmUvC=8-hdCAQwZA4Mz_qHg@mail.gmail.com
Whole thread Raw
In response to Delete performance  (Jarrod Chesney <jarrod.chesney@gmail.com>)
List 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

pgsql-performance by date:

Previous
From: Jarrod Chesney
Date:
Subject: Delete performance
Next
From: Merlin Moncure
Date:
Subject: Re: The shared buffers challenge