agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Pascal Van Puymbroeck <pascal.vanpuymbroeck@zenonproductions.be>
To: pgsql-admin@postgresql.org
Subject: Performance issue
Date: Sat, 05 Feb 2005 10:16:22 +0100
Message-ID: <42048EE6.70007@zenonproductions.be> (raw)

Hi folks,

I would like to solve a strange behaviour I encountered using Postgresql 
8.0.1 on windows.  Connecting to the database is OK, but when running a 
query to the database, its terribly slow.  The fact is that I need the 
database to be running on the same machine, my application is.  So I 
connect to either localhost, 127.0.0.1 or 192.168.0.1.  Strangly enough 
I placed my application on my portable and connected from there to my pc 
and now the queries are amazingly fast. 
Is this something I can fix by some special setting or is it inevitably, 
that connecting locally is punished by a performance slowdown ?

Thanks
Pascal Van Puymbroeck
ZENON productions bvba

view thread (5+ messages)  latest in thread

Message-ID: <42048EE6.70007@zenonproductions.be>
Permalink:  ../42048EE6.70007@zenonproductions.be/
Also on:    postgresql.org/message-id/42048EE6.70007@zenonproductions.be

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: pascal.vanpuymbroeck@zenonproductions.be
  Subject: Re: Performance issue
  In-Reply-To: <42048EE6.70007@zenonproductions.be>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox