Re: [PERFORM] debugging handle exhaustion and 15 min/ 5mil row delete

El 07/05/2010 16:10, Mark Stosberg escribió: You can use TRUNCATE instead DELETE. TRUNCATE is more efficient and faster that DELETE. Thanks for the suggestion. However, TRUNCATE is not compatible with Slony, and we also have some rows which remain in table. Now, we need more info

Re: [PERFORM] debugging handle exhaustion and 15 min/ 5mil row delete

> You can use TRUNCATE instead DELETE. TRUNCATE is more efficient and > faster that DELETE. Thanks for the suggestion. However, TRUNCATE is not compatible with Slony, and we also have some rows which remain in table. > Now, we need more information about your system to give you a certain > so

Re: [PERFORM] debugging handle exhaustion and 15 min/ 5mil row delete

El 07/05/2010 15:37, Mark Stosberg escribió: Hello, We've been a satified user of PostgreSQL for several years, and use it to power a national pet adoption website: http://www.adoptapet.com/ Recently we've had a regularly-timed middle-of-the-night problem where database handles are exhausted fo

Re: [PERFORM] debugging handle exhaustion and 15 min/ 5mil row delete

On Fri, May 07, 2010 at 09:37:42AM -0400, Mark Stosberg wrote: > > Hello, > > We've been a satified user of PostgreSQL for several years, and use it > to power a national pet adoption website: http://www.adoptapet.com/ > > Recently we've had a regularly-timed middle-of-the-night problem where >