> Otherwise you probably didn't gain anything > by splitting your database up like that - you've just reduced the > available resources on that single machine. > Unless that single machine has more resource than a single PG instance can consume to satisfy one query. (see how much faster a greenplum single node can be at some workloads on a server with lots of disk) What is commonly considered commodity hardware often has plenty of spare resources if deployed with stock PG in a data warehouse roll and doesn't have many queries being run against it at any given time. Of course if he doesn't have spare resources on the machine he might just be making his life worse, and far more complex. Just my thoughts, I don't consider myself an expert on the subject matter. Mark -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
