> If I have a customer with 1 database per user, how do they run a query
> against 100 user tables? It would require 100 connections to the
> database. Doing that would require roughly x100 the planning time and
> x100 the connection delay. Larger SQL statements pass their results
> between executor steps using libpq rather than direct calls.
Why is this hypothetical customer using separate databases? This really
seems like a case of "doctor, it hurts when I do this".
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com