Re: [QUESTIONS] MySQL benchmark page

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: luuk_de_boer@pi.net (Luuk de Boer)
Cc: hackers@postgreSQL.org (PostgreSQL-development)
Date: 1998-02-05T16:45:17Z
Lists: pgsql-hackers
[Moved to hackers.]

Can someone take this on?

> 
> > 
> > Great, thanks for testing.  I have a speedup patch I am working on now
> > that will help with any table that has char(), and I think you probably
> > have many of them.  You will see my posting on the questions list.
> > 
> 
> Will test it that's for sure but I would like to ask if it's possible 
> that you run also the crash-me test and the benchmark. When running 
> the crash-me test some strange things happened. I didn't had time to 
> take a look at it but it crashed (postgres) that's for sure .... 
> Further I got some errors I think is interesting for development 
> while running the benchmark.
> Some other things I found:
> postgreSQL isn't compiling with pgcc.
> the memory usage of postgres is big. Very big. Trying to test the 
> maximal number of joins is taking 500 mb of memory testing a join of 
> 55 tables. When I run vacuum postgres takes approx 128 mb of memory. 
> That's a lot I think.
> 
> When there is a new snapshot out just let me know and I will try to 
> test it ... 
> 
> Greetz...
> 
> Luuk
> |-----------------------------------------------------------------------|
> |  Luuk de Boer -> <luuk@pi.net>                                      |
> |  When you want to go fast .....                                       |
> |  Drive a cobra on the road and take a T3 line for internet ...... :-) |
> |  http://www.luuk.com/  -> The AC Cobra site                           |
> |-----------------------------------------------------------------------| 
> 


-- 
Bruce Momjian
maillist@candle.pha.pa.us