Simple SQL too slow

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

Responses

Browse pgsql-performance by date

  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: