Laszlo Nagy <gandalf@xxxxxxxxxxxx> writes: >> If the table has some sort of FK relations it might be being slowed by >> the need to check a row meant to be deleted has any children. >> > If you look at my SQL, there is only one column to be updated. That > column has no foreign key constraint. That was not the question that was asked. > My other idea was that there are so many indexes on this table, maybe > the update is slow because of the indexes? Updating indexes is certainly very far from being free. How many is "many"? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
