From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Too much time to delete 19000 rows
Date: Fri, 06 Oct 2006 14:27:21 -0400
Message-ID: <4246.1160159241@sss.pgh.pa.us> (raw)
In-Reply-To: <55c095e90610061110t5a3040c3pec05bd2c413a85dd@mail.gmail.com>
References: <55c095e90610061110t5a3040c3pec05bd2c413a85dd@mail.gmail.com>
"Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> writes:
> The selection takes less than 1 second but on delete I wait more than 4
> minutes and notthing. Can someone tell me what could happen ?
Perhaps foreign keys referencing this table and no indexes on the
referencing columns? You're not required to have an index on the
referencing side, but you pay for it when you update or delete in
the master table...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, ezequias.rocha@gmail.com
Subject: Re: Too much time to delete 19000 rows
In-Reply-To: <4246.1160159241@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox