Thread: performance optimizations?

performance optimizations?

From
"Robert J. Sanford, Jr."
Date:
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


Re: performance optimizations?

From
Jason Tishler
Date:
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