Re: Multithreaded query onto 4 postgresql instances
От | mark |
---|---|
Тема | Re: Multithreaded query onto 4 postgresql instances |
Дата | |
Msg-id | 000301cbcb1f$8f592580$ae0b7080$@com обсуждение исходный текст |
Ответ на | Re: Multithreaded query onto 4 postgresql instances (Alban Hertroys <dalroi@solfertje.student.utwente.nl>) |
Ответы |
Re: Multithreaded query onto 4 postgresql instances
|
Список | pgsql-general |
> 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
В списке pgsql-general по дате отправления: