Subject: Re: Simple SQL too slow
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>,
 Daviramos Roussenq Fortunato <daviramosrf@gmail.com>,
 pgsql-performance@postgresql.org
References: 
 <CABFgOvotE9gMEkUrBwMPRs60jDiBaX5TXBiVY9jUnjHmYVRXFw@mail.gmail.com>
 <C49D7844-B633-42F6-AF1C-B8D7CD34ECB6@a-kretschmer.de>
 <CABFgOvrcpt1d5OEC5+zqiRQyy2kfvioKHXGY4Qz2kmz2AtSsLg@mail.gmail.com>
 <623C03A8-ABA5-4BF1-8225-348CF5E6848E@a-kretschmer.de>
 <CABFgOvoJ4EsSfCxOCm0i8+Re3V6Q9MnKR4Rj307Pjas7nCbg9Q@mail.gmail.com>
 <7152357d-5cac-20d6-9c08-ea56878c3d03@2ndquadrant.com>
From: Julien Rouhaud <julien.rouhaud@dalibo.com>
Message-ID: <81a45651-ebf9-0df2-5351-5aa71055a58f@dalibo.com>
Date: Sat, 1 Jul 2017 23:17:02 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.0
MIME-Version: 1.0
In-Reply-To: <7152357d-5cac-20d6-9c08-ea56878c3d03@2ndquadrant.com>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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 (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance