Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc G. Fournier
Subject Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
Date
Msg-id 20040101150727.H913@ganymede.hub.org
Whole thread Raw
Responses Re: Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1
List pgsql-general
Tree view 
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@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-general by date:

Previous
From: "Chris Ochs"
Date:
Subject: Re: speeding up inserts
Next
From: Arjen van der Meijden
Date:
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )