| From: | Arjen van der Meijden <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> |
|---|---|
| To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Mnogosearch: Comparing PgSQL 7.4 to MySQL 4.1 |
| Date: | 2004-01-01 19:36:35 |
| Message-ID: | 3FF476C3.2050406@vulcanus.its.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-01-01 19:54:12 | Re: Mnogosearch (Was: Re: website doc search is ... ) |
| Previous Message | Marc G. Fournier | 2004-01-01 19:21:11 | Re: Mnogosearch (Was: Re: website doc search is ... ) |