Message-ID: <521719DF.5040107@archonet.com>
Date: Fri, 23 Aug 2013 09:14:23 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130704 Icedove/17.0.7
MIME-Version: 1.0
To: girish subbaramu <gsubbaramu@hotmail.com>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL 9.2.4 very slow on laptop with windows 8
References: <BAY175-W4988C4F38F7FA122A1C115C44D0@phx.gbl>
In-Reply-To: <BAY175-W4988C4F38F7FA122A1C115C44D0@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance