Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page
Date
Msg-id Pine.NEB.3.95.980205124625.28062X-100000@hub.org
Whole thread Raw
In response to Re: [QUESTIONS] MySQL benchmark page  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
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
>


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: index with nulls
Next
From: Bruce Momjian
Date:
Subject: atttypmod is wrong in system catalogs