On Fri, Jul 24, 2009 at 4:40 PM, MS<fretka1...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
