Skip site navigation (1) Skip section navigation (2)

Re: Perl/DBI vs Native

From: Valentin Bogdanov <valiouk(at)yahoo(dot)co(dot)uk>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Perl/DBI vs Native
Date: 2008-07-22 11:32:28
Message-ID: 698916.49812.qm@web25803.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks to everyone who replied. There were some really good points.

However, I found what is causing the difference. The perl program was connecting to the database via a TCP socket while the C version was using Unix socket. I changed the connect in my perl script, so that it now uses Unix sockets as well. Run the tests again and got identical results for both programs.

In case someone is wondering, the way to force DBI to use unix sockets is by not specifying a host and port in the connect call.


Cheers,

Val


      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html

In response to

Responses

pgsql-performance by date

Next:From: Patrick VachonDate: 2008-07-22 15:15:31
Subject: Re: Difference between 8.1 & 8.3
Previous:From: Ɓukasz FilutDate: 2008-07-22 07:48:34
Subject: Re: Less rows -> better performance?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group