Hello, On 07/01/2017 10:39 PM, Daviramos Roussenq Fortunato wrote:
What tests could I do. Rigid Linux disk is much faster than Windows, I should get a much better perfomace on this Linux. What test battery do you recommend I do?
I'm not sure what you mean by "rigid disk" or "test battery", but I agree with Andreas that clearly there's something wrong at the system level. It's hard to guess what exactly, but sequential scan on 250MB table (computed the relpages values) should only take a few seconds on any decent hardware, and not 3 or 7 minutes.
The first thing I would do is running basic system-level tests, for example benchmarking storage using fio.
After that, you need to determine what is the bottleneck. Perhaps the resources are saturated by something else running on the system - other queries, maybe something else running next to PostgreSQL. Look at top and iotop while running the queries, and other system tools.
regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
