pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedabout performance of postgreSQL
3+ messages / 3 participants
[nested] [flat]
* about performance of postgreSQL
@ 2003-08-12 02:35 xin fu <fx_1978_06_25@yahoo.com.cn>
0 siblings, 1 reply; 3+ messages in thread
From: xin fu @ 2003-08-12 02:35 UTC (permalink / raw)
To: pgsql-performance-owner@postgresql.org
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!?
暑期大片齐聚雅虎通 网络摄像头+雅虎通调频收音机等你来拿
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: about performance of postgreSQL
@ 2003-08-12 17:26 Chris Travers <chris@travelamericas.com>
parent: xin fu <fx_1978_06_25@yahoo.com.cn>
0 siblings, 1 reply; 3+ messages in thread
From: Chris Travers @ 2003-08-12 17:26 UTC (permalink / raw)
To: xin fu <fx_1978_06_25@yahoo.com.cn>; +Cc: pgsql-performance
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/;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: about performance of postgreSQL
@ 2003-08-12 18:02 Josh Berkus <josh@agliodbs.com>
parent: Chris Travers <chris@travelamericas.com>
0 siblings, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2003-08-12 18:02 UTC (permalink / raw)
To: Chris Travers <chris@travelamericas.com>; xin fu <fx_1978_06_25@yahoo.com.cn>; +Cc: pgsql-performance
Xin,
> 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.
Also see these articles:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-08-12 18:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-12 02:35 about performance of postgreSQL xin fu <fx_1978_06_25@yahoo.com.cn>
2003-08-12 17:26 ` Chris Travers <chris@travelamericas.com>
2003-08-12 18:02 ` Josh Berkus <josh@agliodbs.com>
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