From: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
To: pgsql-performance@postgresql.org
Subject: Re: scalability issues on win32
Date: Tue, 23 Nov 2004 00:15:26 +0100
Message-ID: <opshv2v01gcq72hf@musicbox> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A7532@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3412A7532@Herge.rcsinc.local>
> Test platform:
> Pentium 4 3.06 GHz/HT
> 10k SATA Raptor
> 1Gb memory
> Windows XP Pro SP2/Redhat Fedora 3 (64 bit results coming soon)
Could you please add information about...
- filesystems ?
- windows configured as "network server" or as "desktop box" ?
- virtual memory
In my experience you MUST deactivate virtual memory on a Windows box to
avoid catastrophic competition between virtual memory and disk cache
- respective pgsql configurations (buffers...) identical ?
- explain analyze for the two, identical ?
- client on same machine or via network (100Mb ? 1G ?)
- size of the data set involved in query
- first query time after boot (with nothing in the cache), and times for
the next disk-cached runs ?
- are the N users doing the same query or exercising different parts of
the dataset ?
You don't do any writes in your test do you ? Just big SELECTs ?
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: lists@boutiquenumerique.com
Subject: Re: scalability issues on win32
In-Reply-To: <opshv2v01gcq72hf@musicbox>
* 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