Re: [GENERAL] pg_dump out of shared memory

2004-06-27 Thread Tom Lane
[EMAIL PROTECTED] (Thomas F. O'Connell) writes: > Now I'm curious: why does pg_dump require that > max_connections * max_shared_locks_per_transaction be greater than the > number of objects in the database? Not objects, just tables. pg_dump takes AccessShareLock (the weakest kind of lock) on each

Re: [GENERAL] pg_dump out of shared memory

2004-06-27 Thread Thomas F. O'Connell
[EMAIL PROTECTED] (Thomas F. O'Connell) wrote in message news: > postgresql.conf just has the default of 1000 shared_buffers. The > database itself has thousands of tables, some of which have rows > numbering in the millions. Am I correct in thinking that, despite the > hint, it's more likely that