Re: Delete performance

From: Arnau <arnaulist(at)andromeiberica(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Delete performance
Date: 2006-02-22 09:09:50
Message-ID: 43FC2A5E.4080601@andromeiberica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Moritz Bayer 2006-02-22 09:42:35 Installation Postgres 8.1.3 on Linux Suse 9.1
Previous Message Arnau 2006-02-22 09:03:52 Re: how test postgresql.conf settings?