Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1

[Marc G. Fournier]

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?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Arjen van der Meijden]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)