Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
Date: 2004-01-01 19:10:00
Message-ID: 20040101150727.H913@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arjen van der Meijden 2004-01-01 19:14:49 Re: Mnogosearch (Was: Re: website doc search is ... )
Previous Message Chris Ochs 2004-01-01 19:06:20 Re: speeding up inserts