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).