Re: performance optimizations?

Lists: pgsql-cygwin
From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: performance optimizations?
Date: 2001-09-14 14:50:46
Message-ID: HOEFIONAHHKFEFENBMNOCEACCDAA.rsanford@nolimitsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

do i need to worry about performance optimizations running the binary
distribution of cygwin postgresql? for example, do i need to worry
about setting the buffer sizes and shmmax and other such goodies?

if the performance can be optimized somewhat, is there a faq somewhere
correlating the performance notes for linux to cygwin?

thanks!

rjsjr


From: Jason Tishler <jason(at)tishler(dot)net>
To: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
Cc: Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: performance optimizations?
Date: 2001-09-15 02:20:16
Message-ID: 20010914222016.O2272@dothill.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-cygwin

On Fri, Sep 14, 2001 at 09:50:46AM -0500, Robert J. Sanford, Jr. wrote:
> do i need to worry about performance optimizations running the binary
> distribution of cygwin postgresql? for example, do i need to worry
> about setting the buffer sizes and shmmax and other such goodies?

I don't think so, but I don't really know. Maybe someone else on the
list can offer their knowledge.

> if the performance can be optimized somewhat, is there a faq somewhere
> correlating the performance notes for linux to cygwin?

However, you may be interested in the following:

http://archives.postgresql.org/pgsql-cygwin/2001-08/msg00029.php

Specifically, the remark regarding Cygwin vs. Linux performance:

Terry Carlin wrote:
> BTW, Up through 40 users, PostgreSQL under CYGWIN using the TPC-C
> benchmark performed very much the same as Linux PostgreSQL on the
> exact hardware.

Jason