Re: Very slow joins

On Fri, Jul 24, 2009 at 4:40 PM, MS<fretka1990(at)gmail(dot)com> wrote:
>
>> I never cease to be amazed at how many times people have these monster
>> CPUs, like dual quad core 3Ghz processors, with 16GB or whatever of ram,
>> and then try and run a database off a single 7200 rpm desktop SATA
>> drive.    at work our production databases often run on dozens of 10000
>> or 15000 rpm drives, organized as raid1+0's.
>
>
> Yeah. I just took the effort and copied all data from those tables to
> mysql and run an equivalent query - all took around 1 minute to
> execute.
> So either me or postgres is seriously broken. ;) I'm going back to
> mysql. :(

can we see an explain analyze at least?

merlin