Re: Disappointing performance in db migrated from MS SQL Server - Mailing list pgsql-performance

From Chris Ruprecht
Subject Re: Disappointing performance in db migrated from MS SQL Server
Date
Msg-id 200402121719.27666.chris@ruprecht.org
Whole thread Raw
In response to Re: Disappointing performance in db migrated from MS SQL Server  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Disappointing performance in db migrated from MS SQL Server
List pgsql-performance
Bruce,

my bet is on the limited amount of shared memory. The setup as posted by Leon
only shows 80 MB. On a 4 GB database, that's not all that much. Depending on
what he's doing, this might be a bottleneck. I don't like the virtual memory
strategy of Linux too much and would rather increase this to 1 - 2 GB for the
Postgres DB - Specially since he's not running anything else on the machine
and he has 4 GB to play with.

On Thursday 12 February 2004 14:05, Bruce Momjian wrote:
> Leon Out wrote:
[snip]
>
> My only guess is that the tests are I/O bound and therefore the faster
> CPU's aren't helping PostgreSQL.


pgsql-performance by date:

Previous
From: PC Drew
Date:
Subject: Re: Disappointing performance in db migrated from MS SQL Server
Next
From: Josh Berkus
Date:
Subject: Re: Disappointing performance in db migrated from MS SQL Server