On Sun, Sep 27, 2009 at 10:01:27PM +0100, Sam Mason wrote: > Tested by turning on "\timing" mode in psql, dropping > caches and running: > > SELECT 715833344 / 7597.216 / 1024;
Help, I can't do maths! This is overestimating the performance and should be: SELECT 715833344 / 7597.216 / 1024 / 1024 * 1000; After a few more runs to increase confidence, the read performance is 87.17 and a stddev of 2.8. Which seems more reasonable, it should *not* be going above 90MB/s as often as it was. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
