Re: Multithreaded query onto 4 postgresql instances

From: Alessandro Candini <candini(at)meeo(dot)it>
To: mark <dvlhntr(at)gmail(dot)com>
Cc: 'Alban Hertroys' <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Multithreaded query onto 4 postgresql instances
Date: 2011-02-14 08:40:32
Message-ID: 4D58EA80.5020600@meeo.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For shure my life is more complex with this configuration :-D

But the performance tests that I performed (described in the prevoius
thread) tell me that this is a good way...
>> 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
>
>
>
>
>
>
>
>

--
Alessandro Candini

MEEO S.r.l.
Via Saragat 9
I-44122 Ferrara, Italy
Tel: +39 0532 1861501
Fax: +39 0532 1861637
http://www.meeo.it

========================================
"ATTENZIONE:le informazioni contenute in questo messaggio sono
da considerarsi confidenziali ed il loro utilizzo è riservato unicamente
al destinatario sopra indicato. Chi dovesse ricevere questo messaggio
per errore è tenuto ad informare il mittente ed a rimuoverlo
definitivamente da ogni supporto elettronico o cartaceo."

"WARNING:This message contains confidential and/or proprietary
information which may be subject to privilege or immunity and which
is intended for use of its addressee only. Should you receive this
message in error, you are kindly requested to inform the sender and
to definitively remove it from any paper or electronic format."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Basil Bourque 2011-02-14 09:48:03 Re: Upgrading to 9.0 on Mac OS X
Previous Message Alessandro Candini 2011-02-14 08:38:42 Re: Multithreaded query onto 4 postgresql instances