By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1

P: n/a

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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.