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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
