On Sat, Jul 29, 2006 at 08:43:49AM -0700, Joshua D. Drake wrote: > Jochem van Dieten wrote: > >Tweakers.net has done a database performance test between a Sun T2000 (8 > >core T1) and a Sun X4200 (2 dual core Opteron 280). The database > >benchmark is developed inhouse and represents the average query pattern > >from their website. It is MySQL centric because Tweakers.net runs on > >MySQL, but Arjen van der Meijden has ported it to PostgreSQL and has > >done basic optimizations like adding indexes. > > > >Arjen wrote about some of the preliminary results previously in > >http://archives.postgresql.org/pgsql-performance/2006-06/msg00358.php > >but the article has now been published http://tweakers.net/reviews/633/7 > >This is all the more impressive if you scroll down and look at the > >behaviour of MySQL (after tweaking by both MySQL AB and Sun). > > I would love to get my hands on that postgresql version and see how much > farther it could be optimized.
I'd love to get an english translation that we could use for PR. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
