postgres default configuration is very memory-starved. check your pg_hba.conf there are some memory parameters there. most important is the sort buffer size.
On Fri, 03 Sep 2004 17:48:47 +0800, Jason Ngo <[EMAIL PROTECTED]> wrote: > I've searched newsgroups about a work-around in postgres to speed up a > query like: > > SELECT MAX(date) FROM sales; > to > SELECT date FROM sales ORDER by date DESC LIMIT 1; > > But it still takes longer to execute than a max statement in mysql. Is > there any other way to rewrite the statement to match mysql's speed? The > column is already indexed. > -- > Philippine Linux Users' Group (PLUG) Mailing List > [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) > Official Website: http://plug.linux.org.ph > Searchable Archives: http://marc.free.net.ph > . > To leave, go to http://lists.q-linux.com/mailman/listinfo/plug > . > Are you a Linux newbie? To join the newbie list, go to > http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie > -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
