From: Chris Ruprecht <chris@ruprecht.org>
To: pgsql-performance@postgresql.org
Subject: Re: Disappointing performance in db migrated from MS SQL Server
Date: Thu, 12 Feb 2004 17:19:27 -0500
Message-ID: <200402121719.27666.chris@ruprecht.org> (raw)
In-Reply-To: <200402121905.i1CJ5XW13096@candle.pha.pa.us>
References: <200402121905.i1CJ5XW13096@candle.pha.pa.us>
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.
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: chris@ruprecht.org
Subject: Re: Disappointing performance in db migrated from MS SQL Server
In-Reply-To: <200402121719.27666.chris@ruprecht.org>
* 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