Re: Delete performance - Mailing list pgsql-admin

From Arnau
Subject Re: Delete performance
Date
Msg-id 43FC2A5E.4080601@andromeiberica.com
Whole thread Raw
In response to Re: Delete performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Delete performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi all,

> The usual cause of slow deletes is that (a) the table is the target of
> some foreign key references from other large tables, and (b) the
> referencing columns in those tables aren't indexed.

   This is a thing I don't understand, as far as I know the foreign keys
references to primary keys and postgresql creates itself and index over
the primary key, so those columns always should be indexed. Taking into
account Tom's observation I'm missing something, could you explain it to
all of us :)

Thanks
--
Arnau

pgsql-admin by date:

Previous
From: Arnau
Date:
Subject: Re: how test postgresql.conf settings?
Next
From: "Moritz Bayer"
Date:
Subject: Installation Postgres 8.1.3 on Linux Suse 9.1