Re: Performance (was: The New Slashdot Setup (includes MySql server))

From: "Matthias Urlichs" <smurf(at)noris(dot)net>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: The Hermit Hacker <scrappy(at)hub(dot)org>, Alessio Bragadini <alessio(at)albourne(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Performance (was: The New Slashdot Setup (includes MySql server))
Date: 2000-05-19 09:14:24
Message-ID: 20000519111424.I27730@noris.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

Hannu Krosing:
> And now there is a response to your response stating the following
>
That response is from me, actually. (I subscribed to -hackers two hours
ago, so I'm sorry if I missed anything.)

> > That being said, the standard MySQL benchmark _still_ is 30 times
> > faster for MySQL 3.23 than on PostgreSQL 7.0 (with fsync turned off,
> > _and_ nonstandard speed-up PostgreSQL features like VACUUM enabled,
>
> btw, how does one "enable" vacuum ?

run-all-tests ... --fast.

The code has stuff like

$server->vacuum(1,\$dbh) if $opt_fast and defined $server->{vacuum};

sprinkled at strategic places.

--
Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
The quote was selected randomly. Really. | http://smurf.noris.de/
--
Silence is the element in which great things fashion themselves.
--Thomas Carlyle

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2000-05-19 10:12:36 Does Order by support case?
Previous Message Dustin Sallings 2000-05-19 08:37:24 Re: Performance

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Vazsonyi 2000-05-19 09:52:05 -devel-7.0-1.rpm: Still missing a lots of headers
Previous Message Andrzej Mazurkiewicz 2000-05-19 08:24:55 RE: OO Patch