On 23 January 2017 at 17:55, Gabriel Dodan <gabriel.do...@gmail.com> wrote: > > BUT if I run a trivial select on both servers, on a similar table, the select > perform much much better on second server!
You're comparing two very different systems it seems, therefore you might be looking at difference in the performance of EXPLAIN, just getting timing information of your system may be the most expensive part[1], you could disable the timing explicity: EXPLAIN (ANALYZE ON, TIMING OFF) <query> And, there is something that stands out: So it seems there is also some difference in the data, we could validate the actual numbers: SELECT sum(pg_column_size(symbols_tests))/count(*) FROM symbols_tests; regards, Feike [1] https://www.postgresql.org/docs/current/static/using-explain.html#USING-EXPLAIN-CAVEATS
