X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 0EB378B9B50
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Sat,  5 Feb 2005 09:16:39 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 99233-07
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Sat,  5 Feb 2005 09:16:23 +0000 (GMT)
Received: from asia.telenet-ops.be (asia.telenet-ops.be [195.130.132.59])
	by svr1.postgresql.org (Postfix) with ESMTP id 585848B9B27
	for <pgsql-admin@postgresql.org>; Sat,  5 Feb 2005 09:16:24 +0000 (GMT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by asia.telenet-ops.be (Postfix) with SMTP id 8F9F02243FA
	for <pgsql-admin@postgresql.org>; Sat,  5 Feb 2005 10:16:23 +0100 (MET)
Received: from [127.0.0.1] (dD5778727.access.telenet.be [213.119.135.39])
	by asia.telenet-ops.be (Postfix) with ESMTP id 6E7632243F4
	for <pgsql-admin@postgresql.org>; Sat,  5 Feb 2005 10:16:23 +0100 (MET)
Message-ID: <42048EE6.70007@zenonproductions.be>
Date: Sat, 05 Feb 2005 10:16:22 +0100
From: Pascal Van Puymbroeck <pascal.vanpuymbroeck@zenonproductions.be>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.3) Gecko/20040910
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Performance issue
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.105 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200502/46
X-Sequence-Number: 16214

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