On Fri, Feb 12, 2016 at 8:09 AM, Sterpu Victor <victor@caido.ro> wrote:
> There are some differences that I haven't mentioned.
> Postgres on Linux is PostgreSQL 9.1.4 64 bit
> Postgres on Windows is PostgreSQL 9.5.0, compiled by Visual C++ build 1800,
> 64-bit
>
> The query is very big but I pasted it at the end of the mail with the
> EXPLAIN ANALYZE.
> I runned the queries many times on every machine, the cache is not involved.
>
> postgresql.conf are defaults, I haven't compared them yet but I will.
>
>
> "Limit (cost=163011.25..163011.63 rows=1 width=3640) (actual
> time=2811.693..2812.109 rows=20 loops=1)"
This seems to be the `explain analyze` for the fast one. Can you also
post it for the slow one?
Also, for version 9.5 can you turn on track_io_timing and post the
output of EXPLAIN (analyze, buffers)? Please do that separately from
the regular EXPLAIN ANALYZE though, to make it one of them easier to
compare to the one from version 9.1.