pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
about 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