Re: [GENERAL] localhost (windows) performance

2008-10-08 Thread johnf
On Tuesday 07 October 2008 08:11:05 am johnf wrote: > I have a friend I asked to load postgres 8.3 on his XP machine. He then > tested a python script which accesses several tables and discovered that it > retrieves data very slowly. It takes about 20 seconds to retrieve the data > - on localhost

Re: [GENERAL] localhost (windows) performance

2008-10-08 Thread Scott Marlowe
Note that there are also some issues in some flavors of windows with a QOS setting that gives pgsql network traffic a low priority. I'm not that familiar with it, I've just seen it mentioned. There's also some issues that can come up with dns resolution and network communication. Just throwing t

Re: [GENERAL] localhost (windows) performance

2008-10-08 Thread Scott Marlowe
Note that there are also some issues in some flavors of windows with a QOS setting that gives pgsql network traffic a low priority. I'm not that familiar with it, I've just seen it mentioned. There's also some issues that can come up with dns resolution and network communication. Just throwing t

Re: [GENERAL] localhost (windows) performance

2008-10-07 Thread johnf
On Tuesday 07 October 2008 08:54:31 am justin wrote: > johnf wrote: > > I have a friend I asked to load postgres 8.3 on his XP machine. He then > > tested a python script which accesses several tables and discovered that > > it retrieves data very slowly. It takes about 20 seconds to retrieve the

Re: [GENERAL] localhost (windows) performance

2008-10-07 Thread justin
johnf wrote: I have a friend I asked to load postgres 8.3 on his XP machine. He then tested a python script which accesses several tables and discovered that it retrieves data very slowly. It takes about 20 seconds to retrieve the data - on localhost. However, using a remote connection to a

Re: [GENERAL] localhost (windows) performance

2008-10-07 Thread johnf
On Tuesday 07 October 2008 08:20:16 am you wrote: > On Tue, Oct 7, 2008 at 11:11 AM, johnf <[EMAIL PROTECTED]> wrote: > > I then thought it had something to do with the data -although the data > > set is small. I did a complete dump and restored on his machine and > > again got the same results.

[GENERAL] localhost (windows) performance

2008-10-07 Thread johnf
I have a friend I asked to load postgres 8.3 on his XP machine. He then tested a python script which accesses several tables and discovered that it retrieves data very slowly. It takes about 20 seconds to retrieve the data - on localhost. However, using a remote connection to a postgres datab