Re: Comparative performance - Mailing list pgsql-performance

From Joe
Subject Re: Comparative performance
Date
Msg-id 4342EFF7.5010405@freedomcircle.net
Whole thread Raw
In response to Re: Comparative performance  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Comparative performance  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: Comparative performance  ("Dario" <dario_d_s@unitech.com.ar>)
List pgsql-performance
Hi Jim,

Jim C. Nasby wrote:
> Also, just because no one else has mentioned it, remember that it's very
> easy to get MySQL into a mode where you have no data integrity. If
> that's the case it's going to be faster than PostgreSQL (though I'm not
> sure how much that affects the performance of SELECTs).

Yes indeed.  When I added the REFERENCES to the schema and reran the conversion
scripts, aside from having to reorder the table creation and loading (they used
to be in alphabetical order), I also found a few referential integrity errors in
the MySQL data.

Joe


pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Lists or external TABLE?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Is There Any Way ....