Re: [HACKERS] Warning for exceeding max locks?

2007-07-15 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: We ran into a problem with a customer this weekend. They had >128,000 tables and we were trying to run a pg_dump. When we reached max_locks_per_transaction, the dump just hung waiting to lock the next table. Would it make sense t

Re: [HACKERS] Warning for exceeding max locks?

2007-07-14 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > We ran into a problem with a customer this weekend. They had >128,000 > tables and we were trying to run a pg_dump. When we reached > max_locks_per_transaction, the dump just hung waiting to lock the next > table. > Would it make sense to have som

[HACKERS] Warning for exceeding max locks?

2007-07-14 Thread Joshua D. Drake
Hello, We ran into a problem with a customer this weekend. They had >128,000 tables and we were trying to run a pg_dump. When we reached max_locks_per_transaction, the dump just hung waiting to lock the next table. Would it make sense to have some sort of timeout for that? wait_for_lock_tim