From: Harald Armin Massa <haraldarminmassa@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: measuring shared memory usage on Windows
Date: Fri, 20 Oct 2006 10:12:19 +0200
Message-ID: <7be3f35d0610200112r62185561uedb9276b784ec273@mail.gmail.com> (raw)
In-Reply-To: <7be3f35d0610161330r4df390f2uecf8d411c861911c@mail.gmail.com>
References: <7be3f35d0610160518h649c8f20pee9949a90796c346@mail.gmail.com>
<6BCB9D8A16AC4241919521715F4D8BCEA357F5@algol.sollentuna.se>
<7be3f35d0610161330r4df390f2uecf8d411c861911c@mail.gmail.com>
Performance readers ....
I follow up my promise:
> I try my theories :)) and contrary to all wisdom from all PostgreSQL
> tuning recommendations reconfigured shared memory nearly to the
> minimum: 1000 for maximum of 400 concurrent connections. (800 would be
> minimum). Single user performance was fine, now I am looking forward
> to full user scenario tomorrow.
>
> I will keep you posted.
>
> Harald
I went even further down,
max_connections = 200 #
shared_buffers = 400 # min 16 or max_connections*2, 8KB each
to the minimum allowed value of shared_buffers. And the response times are
better then ever before (with 10.000, 20.000, 5.000 and 40.000shared_buffers):
An application-level response dropped from 16 / 9.5 seconds (first run /
cached run) to 12 / 6.5 average runtime. That response time is mainly
dependend on SQL performance, and esp. the drop is caused by this change.
Moreover, the columns "swapped out memory" in task manager stay low at ~26k
per postgres.exe, compared to ~106k as my shared_buffers where at 10.000.
The "memory" column of postgres.exe in task manager process still grows up
to >10.000K, while now "virtual memory" stays ~3.600k per process
So: in this configuration / workload:
-> windows 2k3
-> small (~0,4GB) Database
-> rather complex queries
-> ~1 GB memory
-> running in virtual machine
and
-> windows xp
-> small (~0,4GB) Database
-> ~0,5 GB memory
-> rather complex queries
-> running native (laptops)
I could verify a substantial speed gain in single and many user situations
by lowering shared_buffers to the allowed minimum.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: haraldarminmassa@gmail.com
Subject: Re: measuring shared memory usage on Windows
In-Reply-To: <7be3f35d0610200112r62185561uedb9276b784ec273@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox