I have a Server where a simple SQL is taking a long time to return the results the Server settings are as follows:
Debian GNU/Linux 7 (wheezy)
CPU: Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
Mem: 16GB
HD: SSG 120 GB
Postgresql 9.2
postgresql.conf
shared_buffers = 1536MB
work_mem = 32MB
maintenance_work_mem = 960MB
effective_cache_size = 4864MB
I did a test with the following SQL:
select * from MINHATABELA
It took 7 minutes to return the result.
I did the same test on a Server:
Windows Server 2012 Standard
CPU: Intel(R) Xeon(R) CPU E5-2450 @ 2.10GHz
Mem: 24GB
HD: HD 500 GB
Postgresql 9.2
postgresql.conf Default settings that come with the installation
The same SQL returned in 3 minutes.
The test in both Servers were done bench.
This table has 1888240 records whose size is 458 MB
I believe that in both Servers the response time of this SQL is very high, but the main thing in LINUX Server has something very wrong, I think it is something in the settings.
What can I be checking?