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

Performance issue

From: Pascal Van Puymbroeck <pascal(dot)vanpuymbroeck(at)zenonproductions(dot)be>
To: pgsql-admin(at)postgresql(dot)org
Subject: Performance issue
Date: 2005-02-05 09:16:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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, or  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 ?

Pascal Van Puymbroeck
ZENON productions bvba


pgsql-admin by date

Next:From: Tom LaneDate: 2005-02-05 16:53:56
Subject: Re: Performance issue
Previous:From: Joshua D. DrakeDate: 2005-02-05 01:36:13
Subject: Re: PG 8 Out of memory issuing queries

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