From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | girish subbaramu <gsubbaramu(at)hotmail(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL 9.2.4 very slow on laptop with windows 8 |
Date: | 2013-08-23 08:14:23 |
Message-ID: | 521719DF.5040107@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Ma'ruf | 2013-08-26 05:09:59 | Poor performance on simple queries compared to sql server express |
Previous Message | Imre Samu | 2013-08-22 15:25:51 | Re: PostgreSQL 9.2.4 very slow on laptop with windows 8 |