Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id EC1EB650169 for ; Thu, 20 Nov 2008 05:29:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82547-03 for ; Thu, 20 Nov 2008 05:29:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id E6786650154 for ; Thu, 20 Nov 2008 05:29:49 -0400 (AST) Received: (qmail 20660 invoked by uid 0); 20 Nov 2008 09:29:47 -0000 Received: from 192.124.237.8 by www097.gmx.net with HTTP; Thu, 20 Nov 2008 10:29:47 +0100 (CET) Content-Type: text/plain; charset="iso-8859-1" Date: Thu, 20 Nov 2008 10:29:47 +0100 From: "Jan-Peter Seifert" Message-ID: <20081120092947.324160@gmx.net> MIME-Version: 1.0 Subject: shared memory on Windows? To: pgsql-admin@postgresql.org X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX198E+sFpsl8p7dE/Dzh6Y0inwNZy69BtrkGUKRTuS 6f5qitB2C4W4Mxqf7fhn5aAXMV6MmZJGas5Q== Content-Transfer-Encoding: 8bit X-GMX-UID: OVQQIcsUZDIrBU+ldGY2Z0t5emhmY4EV X-FuHaFi: 0.64 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/125 X-Sequence-Number: 30779 Hello, I wonder what the current status of shared memory on Windows and PostgreSQL is. http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#SYSVIPC says "On Windows, PostgreSQL provides its own replacement implementation of these facilities". I didn't find any details on this. Just this older thread for example. http://archives.postgresql.org/pgsql-hackers/2008-03/msg01081.php So is PostgreSQL (could still be) using the Swapfile on Windows? Should one let Windows decide on the size of the swapfile as usual then? Is it still "keep shared buffers as small as possible on Windows"? I guess the 32MB is just a "Windows default"? Thank you very much, Peter -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger