List Info

Thread: Pgpool II w/ Postgres - Confirm/Deny Execution Times
Pgpool II w/ Postgres - Confirm/Deny Execution Times
user name
 2008-04-25 11:23:40 

  


  

    

Hello all,


 


I'm new to the Postgres + PGPool II world and so 
would like some assurance from you experts that the behavior I'm seeing is 
normal/expected with relation to PGPool .


 


Here is what I have: ; PGPool II 2.0.1 with 
Postgres 8.2.7 and PHP 5 running on Centos 5.


 


I have a very simple PHP script that connects to 
the db, issues a select and loops the array and writes it out.   The 
script has a simple microtime calculation that tells me how long it took to 
process the page. 


 


Without PGPool , the execution time ranges from 
.038 - .042 seconds. 


With PGPool , the execution time increase anywhere 
between .052 - .076 seconds.  


 


That's with using pg_connect in my 
PHP ;script.  


 


Now, I was expecting it to go down with PGPool 
since the time to create a connection should be eliminated by using a pool. 



 


As a comparison, when I use pg_pconnect, the 
execution times drop down to .013 seconds.  I have read enough to keep me 
away from using pg_pconnect and thus go down the route of using PGPool. 



 


Is that normal to see higher execution times with 
PGPool enabled?  Or do I not have it setup correctly?  


 


I can post the config file if that would help. 



 


Thanks in advance.


Amin 


 ;

  

  
  
   
     
    

  

    Re:  Pgpool II w/ Postgres -
Confirm/Deny	Execution Times
  


  

     country flaguser name
Switzerland		
     2008-04-29 07:06:52
  


  

    
Hello Amin!

Amin Mirza [Fri, Apr 25, 2008 at 10:23:40AM -0600]:
> Is that normal to see higher execution times with
PGPool enabled?  Or do I not have it setup correctly?  
Yes. When you add pgpool between your client and postgres
the needed time
MUST increase, as you add overhead.

You can distribute queries to more than one server in load
balancing
mode, thus having better performance when using more than
one concurrent
connection in select()s.

Though the time for data changes (insert, update, ...) will
increase,
as it needs to be replicated to all nodes.

Sincerly

Nico


-- 
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/th
e-term-foss/

PGP: BFE4 C736 ABE5 406F 8F42  F7CF B8BE F92A 9885 188C

_______________________________________________
Pgpool-general mailing list
Pgpool-generalpgfoundry.org

http://pgfoundry.org/mailman/listinfo/pgpool-general



  


  

    
  

  
  
   
     
    






 [1-2]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )