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

From Bruce Momjian
Subject Re: [QUESTIONS] MySQL benchmark page
Date
Msg-id 199802051645.LAA01279@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page  (The Hermit Hacker <scrappy@hub.org>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Bug?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [QUESTIONS] impossible insert data into VARCHAR