Re: 2 machines, same database, same query, 10 times slower?

On 8.5.2012 20:32, Antonio Goméz Soto wrote:
>> > Do this on both machines to verify that
>> >
>> >    SELECT relpages, reltuples FROM pg_class WHERE relname = 'cdr';
> Slow machine:
>
>  relpages | reltuples
> ----------+-----------
>    400566 |    982321
>
> Fast machine:
>
>  relpages |  reltuples
> ----------+-------------
>     62076 | 1.48375e+06
>
>

Yup, that's probably the culprit. The slow machine has to read 400000
pages while the fast one just 62000. Each page is 8kB, so this is 3GB
vs. 500MB difference.

T.