public inbox for [email protected]
help / color / mirror / Atom feedFrom: Julien Rouhaud <[email protected]>
To: Tomas Vondra <[email protected]>
To: Daviramos Roussenq Fortunato <[email protected]>
To: [email protected]
Subject: Re: Simple SQL too slow
Date: Sat, 1 Jul 2017 23:17:02 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CABFgOvotE9gMEkUrBwMPRs60jDiBaX5TXBiVY9jUnjHmYVRXFw@mail.gmail.com>
<[email protected]>
<CABFgOvrcpt1d5OEC5+zqiRQyy2kfvioKHXGY4Qz2kmz2AtSsLg@mail.gmail.com>
<[email protected]>
<CABFgOvoJ4EsSfCxOCm0i8+Re3V6Q9MnKR4Rj307Pjas7nCbg9Q@mail.gmail.com>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On 01/07/2017 22:58, Tomas Vondra wrote:
> 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.
>
Another explanation would be network issue. Are they stored in
different locations? And dhoes
EXPLAIN ANALYZE select * from MINHATABELA
has similar timings on both environment?
Also, I didn't see any indication about how exactly were the tests
performed. Was it using psql, pgAdmin or something else ?
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org
--
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], [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