Search Postgresql Archives

Re: localhost (windows) performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.  However, using a remote connection to a postgres database
> (mine) over the internet and running the same python script it takes only
> 12 seconds.  The difference of 8 seconds makes no sense - the remote is
> completely on the other coast.
>
> 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.  The machine has a recent motherboard with 2 gb of ram. 
> It does not appear to be swapping out ram.
>
>
> Using my local XP (accessing the LINUX database on the LAN) runs the same
> python script in just under 3 seconds (most of the time is in loading the
> GUI).
>
> One other major difference is I'm running postgres8.2 on linux.
>
> Anybody, have a suggestion - I'm not a windows guru.  Or is this normal for
> windows?
> --
> John Fabiani

The followup:

We decided to switch machines.  The performance is now acceptable.  Thanks to 
all who took the time to consider the issue.

-- 
John Fabiani


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux