public inbox for [email protected]
help / color / mirror / Atom feedFrom: Tomas Vondra <[email protected]>
To: Daviramos Roussenq Fortunato <[email protected]>
To: [email protected]
Subject: Re: Simple SQL too slow
Date: Sat, 1 Jul 2017 22:58:30 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CABFgOvoJ4EsSfCxOCm0i8+Re3V6Q9MnKR4Rj307Pjas7nCbg9Q@mail.gmail.com>
References: <CABFgOvotE9gMEkUrBwMPRs60jDiBaX5TXBiVY9jUnjHmYVRXFw@mail.gmail.com>
<[email protected]>
<CABFgOvrcpt1d5OEC5+zqiRQyy2kfvioKHXGY4Qz2kmz2AtSsLg@mail.gmail.com>
<[email protected]>
<CABFgOvoJ4EsSfCxOCm0i8+Re3V6Q9MnKR4Rj307Pjas7nCbg9Q@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Simple SQL too slow
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox