On Mon, Apr 8, 2013 at 12:31 PM, Mark Davidson <mark@4each.co.uk> wrote:
Thanks for your response Vasillis. I've run pgbench on both machines `./pgbench -c 10 -t 10000 pgbench` getting 99.800650 tps on my local machine and 23.825332 tps on the server so quite a significant difference.
These results are almost certainly being driven by how fast your machines can fsync the WAL data. The type of query you originally posted does not care about that at all, so these results are not useful to you. You could run the "pgbench -S", which is getting closer to the nature of the work your original query does (but still not all that close).