Re: PostgreSQL 9.2.4 very slow on laptop with windows 8

On 22/08/13 12:30, girish subbaramu wrote:
>
> I am running PostgreSQL 9.2.4 on windows 8  , 64 bit operating system ,
> 4GB RAM.

> A laptop with i3 - 3110M , 2.4 GHZ .
> The database  came bundled with wapp stack 5.4.17-0. We have an php
> application that serves data from PostgreSQL 9.2.4.
>
> The configuration runs with very good performance (3 sec response php +
> db ) on windows 7   32, 64 bit OS , 4GB RAM (desktops with i3-2100 3.10
> GHZ ) .
> But take around 25 seconds to render on windows 8 , the laptop.
>
> I was able to eliminate php , as the performance was as expected.
> (without DB calls)
> On the other part the database calls take more than 100 ms for simple
> queries (Example a table with just 10 row sometimes takes around 126
> ms).  This information i was able to collect from the pg_log.

First step - check the antivirus / security tools aren't interfering. 
That can slow you down immensely.

Second step - have a quick look in your performance monitoring (you can 
get to it through

-- 
   Richard Huxton
   Archonet Ltd