Re: Long-running DELETE

On 15 Jan 2002, Jeff Boes wrote:

> Okay, this is really starting to fry me:
>
> I'm trying to delete 1000 rows from a table which is referenced by
> several different other tables as a foreign key.  I've turned on
> debug_print_query to help track this down.  When I do deletes from
> some tables, I can delete hundreds of rows per second.  When I delete
> from the main table, it's about 1 row per second.  I've turned off
> every trigger in the database:
>
> update pg_triggers set tgenabled=false;

I don't think tgenabled works.  You'll probably need to set reltriggers to
0 on the pg_class row for the table (and then reset it to the correct
value afterwards).