Thread

  1. Re: [QUESTIONS] MySQL benchmark page

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-05T16:45:17Z

    [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
    
    
  2. Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page

    Marc G. Fournier <scrappy@hub.org> — 1998-02-05T17:46:57Z

    On Thu, 5 Feb 1998, Bruce Momjian wrote:
    
    > [Moved to hackers.]
    > 
    > Can someone take this on?
    
    	I have it all downloaded at home...I dive into it and get it
    included as part of our src/test directory...
    
    
    
    > 
    > > 
    > > > 
    > > > 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
    >