From: | Daviramos Roussenq Fortunato <daviramosrf(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Simple SQL too slow |
Date: | 2017-06-30 19:14:33 |
Message-ID: | CABFgOvotE9gMEkUrBwMPRs60jDiBaX5TXBiVY9jUnjHmYVRXFw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi List,
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?
--
Atenciosamente
Daviramos Roussenq Fortunato
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2017-06-30 19:50:45 | Re: Simple SQL too slow |
Previous Message | Jeff Janes | 2017-06-30 17:46:45 | Re: |