> 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. :(
