Re: Multithreaded query onto 4 postgresql instances - Mailing list pgsql-general
From | Alessandro Candini |
---|---|
Subject | Re: Multithreaded query onto 4 postgresql instances |
Date | |
Msg-id | 4D5B90E3.3080009@meeo.it Whole thread Raw |
In response to | Re: Multithreaded query onto 4 postgresql instances (Alban Hertroys <dalroi@solfertje.student.utwente.nl>) |
Responses |
Re: Multithreaded query onto 4 postgresql instances
|
List | pgsql-general |
Il 15/02/2011 19:32, Alban Hertroys ha scritto: > On 15 Feb 2011, at 9:32, Alessandro Candini wrote: > >>> Is that a single query on that one DB compared to 4 queries on 4 DB's? How does a single DB with 4 parallel queries perform?I'd expect that to win from 4 DB's, due to the overhead those extra DB instances are generating. >> Maybe my configuration and test is not clear > It is clear. I gave you another suggestion for something to try instead. > >> Splitted instances: >> 600 millions of records in total splitted into 4 postgresql instances (port 5433, 5434, 5435, 5436), let's say more orless: >> >> 5433 ---> 150 millions of records >> 5434 ---> 150 millions of records >> 5435 ---> 150 millions of records >> 5436 ---> 150 millions of records > Try the above on a single DB using 4 threads. It will very probably perform better. > To use your example: > 5432 ---> 150 million records > 5432 ---> 150 million records > 5432 ---> 150 million records > 5432 ---> 150 million records > Excuse me but query must to be performed on the whole db...with your approach, how to merge results of every query in one single response? >>> Did you read all the way to section 35.9.10? That explains how to create SRF's like yours, including examples. If thestep from simple functions to SRF's is too large for you, create a few sample-functions to learn how the intermediarysteps work. We can't upload the info to your brain, after all - you'll have to do the learning part by yourself. >>> >> Do you think is a good idea continue using libpq or should I abandon them and focus on postgresql documentation examples? > To learn how to write functions like these? Best to use a simple case so it's clear what's going on. If you try to alteralready complicated code for that purpose you'll probably just get more confused. > > Alban Hertroys > > -- > Screwing up is an excellent way to attach something to the ceiling. > > > !DSPAM:1234,4d5ac6b211738438191676! > > -- 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."
pgsql-general by date: