Lars Feistner <feistner@xxxxxxxxxxxxxxxxx> wrote: > The log tells me that certain update statements take sometimes > about 3-10 minutes. But we are talking about updates on tables > with 1000 to 10000 rows and updates that are supposed to update 1 > row. The top possibilities that come to my mind are: (1) The tables are horribly bloated. If autovacuum is off or not aggressive enough, things can degenerate to this level. (2) Memory is over-committed and your machine is thrashing. (3) There are explicit LOCK commands in the software which is contributing to the blocking. (4) There is some external delay within the transaction, such as waiting for user input while the transaction is open. Maybe there's a combination of the above at play. Can you rule any of these out? -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
