Re: Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1 - Mailing list pgsql-general

From Arjen van der Meijden
Subject Re: Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
Date
Msg-id 3FF476C3.2050406@vulcanus.its.tudelft.nl
Whole thread Raw
In response to Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-general
Marc G. Fournier wrote:

> On a whim, I'm loading up the search engine under both ... the 7.4 has
> WITHOUT OIDs "enabled" on all tables ...
>
> So far, with ~2k URLs indexed on both systems, the MySQL uses 1/3 the disk
> space of PgSQL:
>
> mysql41# du 186_archives
> 20018   186_archives
>
> vs PgSQL:
>
> 64761   149979575
>
> going to be interesting to see the end result ...
>
> Does anyone know if MySQL has an equivalent to EXPLAIN ANALYZE, or aren't
> they that advanced yet?

They don't have that. Just the 'normal' explain which doesn't explain
very much... I can read them, but not always fully understand them. (it
is a thing I occasionally really miss in mysql).

The difference in size is a bit odd I'd say?
Was that a fully vacuumed/new relation?

Btw, I wouldn't deem mysql 4.1 production-stable, perhaps you should
compare it with 4.0.17?

Regards,

Arjen



pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )
Next
From: Tom Lane
Date:
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )