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