Re: [PERFORM] pg_restore causes 100

2007-07-12 Thread Tom Lane
Craig James <[EMAIL PROTECTED]> writes: > Now here's the weird thing. I'm running a pg_restore of a database > (on the order of 4GB compressed, maybe 34M rows of ordinary data, and > 15M rows in one BLOB table that's typically 2K per blob). When I do > this, ALL of the postgress backends start wo

[PERFORM] pg_restore causes 100

2007-07-12 Thread Craig James
Here's an oddity. I have 10 databases, each with about a dozen connections to Postgres (about 120 connections total), and at midnight they're all idle. These are mod_perl programs (like a FastCGI -- they stay connected so they're ready for instant service). So using "ps -ef" and grep, we fin