From: Chris Travers <chris@travelamericas.com>
To: xin fu <fx_1978_06_25@yahoo.com.cn>
Cc: pgsql-performance@postgresql.org
Subject: Re: about performance of postgreSQL
Date: Tue, 12 Aug 2003 10:26:17 -0700
Message-ID: <3F392339.5000007@travelamericas.com> (raw)
In-Reply-To: <20030812023504.27034.qmail@web15106.mail.bjs.yahoo.com>
References: <20030812023504.27034.qmail@web15106.mail.bjs.yahoo.com>
Hi Xin;
PostgreSQL is configured to run on virutally anything out of the box.
The reason for this is that, like Oracle, the database manager will not
start if it cannot allocate sufficient resources. We take the approach
of ensuring that it will start so you can tune it.
I would recomment trying to take a close look at many of the posts on
the Performance list (searching the archives) and paying attention to
things such as effective_cache_size and shared_buffers. If these don't
answer your questions, ask this list again.
Best Wishes,
Chris Travers
xin fu wrote:
> Dear master:
> I have learned postgreSQL for serveral days, now i meet some problems.
> when I use a TPCC(Transaction Processing Performance Council) test
> program to test the performance of postgreSQL , postgreSQL works very
> slowly, it almost need 1 minute to finish a transaction, and the CPU
> percent is almost 100%,
> the test environment is :
> OS: redhat 9.0(ext3, default configurations)
> Server: postgre7.3.4(default configurations) , PIII 800M, 1G Memory
> Client: tpcc test program,using ODBC API, PIII 800M, 1G Memory
> when using SQLServer, it can work on a workload of 40 Warehouse,
> but postgreSQL can not work even on 1 warehouse. I think there must be
> some problem with my postgreSQL, can you help me?
> I am in china, and my english is very poor, but i hope you can give
> me some advice, thanks.
>
>
> ------------------------------------------------------------------------
> *Do You Yahoo!?*
> 暑期大片齐聚雅虎通 网络摄像头+雅虎通调频收音机等你来拿
> <http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.promo.yahoo.com/minisite/messenger1/;
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: chris@travelamericas.com, fx_1978_06_25@yahoo.com.cn
Subject: Re: about performance of postgreSQL
In-Reply-To: <3F392339.5000007@travelamericas.com>
References: <20030812023504.27034.qmail@web15106.mail.bjs.yahoo.com> <3F392339.5000007@travelamericas.com>
* 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