Markus Schiltknecht wrote:
For dbt2, I've used 500 warehouses and 90 concurrent connections, default values for everything else.
500? That's just too much for the hardware. Start from say 70 warehouses and up it from there 10 at a time until you hit the wall. I'm using 30 connections with ~100 warehouses on somewhat similar hardware.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com