And ofcourse, you ran ANALYZE before doing any timings, right? On Tue, Nov 25, 2003 at 01:08:55PM +0100, Marek Lewczuk wrote: > Hello, > I have changed DB from MySQL to PostgreSQL. When I have run my > application on PostgreSQL it was disaster - it was much slower than > MySQL... > > I have tried to change PG configuration file etc.. no luck. After many > long days of thinking what is wrong I have made several tests with > "EXPLAIN" statement, and to my amusement there was many SeqScan - MySQL > didn't show that things. I have made some changes in PG db structure > (new indexes etc) and then I have made another test: PostgreSQL time - > 10ms, MySQL time - 1 sec. I've tried to change the structure in MySQL > but it didn't change the results. > > So my advise for all users which think that MySQL is faster than PG - > re-check your DB structure, check all your querys using EXPLAIN... maybe > new indexes should be added etc. > > > Regards, > Marek > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly
-- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > "All that is needed for the forces of evil to triumph is for enough good > men to do nothing." - Edmond Burke > "The penalty good people pay for not being interested in politics is to be > governed by people worse than themselves." - Plato
pgp00000.pgp
Description: PGP signature
