> 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. :( -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general