Re: performance is slow

Pipe gives me 2x over localhost. Need to tell the postgresql guys...

On Wed, 2009-06-10 at 23:22 +0200, Federico Di Gregorio wrote:
> Il giorno mer, 10/06/2009 alle 14.18 -0700, Tim Roberts ha scritto:
> > Al Niessner wrote:
> > > Any more suggestions on how to speed things up? The one thing that I do
> > > not like is that I see the network usage sky rocket during this time. Is
> > > there a way that I can have a pipe connection instead of network?
> > >   
> > 
> > Is your database on the same machine as your script?  Are you specifying
> > host='localhost' when you open the connection?  If you specify a full
> > host name, then it's probably connecting to your externally visible IP
> > address.
> 
> That is, if the database and the script are on the same server just
> specify the database name and, as an option, username and password.
> Don't specify the host or port.
> 
> federico
> 
> _______________________________________________
> Psycopg mailing list
> Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
> http://lists.initd.org/mailman/listinfo/psycopg
-- 
Al Niessner

I have never found the companion that was so companionable as solitude.
- From Walden by Henry David Thoreau

The universe is indifferent, and life is brutal; however, it is man's
choice of behavior that makes them malevolent rather than benevolent.

Some will fall in love with life and drink it from a fountain
That is pouring like an avalanche coming down the mountain.
- From the song Pepper by the Butthole Surfers