From: Lane Van Ingen <lvaningen@esncc.com>
To: pgsql-performance@postgresql.org
Subject: Is There A Windows Version of Performance Tuning Documents?
Date: Wed, 3 Aug 2005 09:15:34 -0400
Message-ID: <EKEMKEFLOMKDDLIALABICEEPCAAA.lvaningen@esncc.com> (raw)
I have in my possession some performance tuning documents authored by Bruce
Momjian, Josh Berkus, and others. They give good information on utilities to
use (like ipcs, sar, vmstat, etc) to evaluate disk, memory, etc. performance
on Unix-based systems.
Problem is, I have applications running on Windows 2003, and have worked
mostly on Unix before. Was wondering if anyone knows where there might be a
Windows performance document that tells what to use / where to look in
Windows for some of this data. I am thinking that I may not seeing what I
need
in perfmon or the Windows task manager.
Want to answer questions like:
How much memory is being used for disk buffer cache?
How to I lock shared memory for PostgreSQL (if possible at all)?
How to determine if SWAP (esp. page-in) activity is hurting me?
Does Windows use a 'unified buffer cache' or not?
How do I determine how much space is required to do most of my sorts in
RAM?
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: lvaningen@esncc.com
Subject: Re: Is There A Windows Version of Performance Tuning Documents?
In-Reply-To: <EKEMKEFLOMKDDLIALABICEEPCAAA.lvaningen@esncc.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