Re: [PERFORM] Simple SQL too slow - Mailing list pgsql-performance

From Julien Rouhaud
Subject Re: [PERFORM] Simple SQL too slow
Date
Msg-id 81a45651-ebf9-0df2-5351-5aa71055a58f@dalibo.com
Whole thread Raw
In response to Re: [PERFORM] Simple SQL too slow  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: [PERFORM] Simple SQL too slow  (Daviramos Roussenq Fortunato <daviramosrf@gmail.com>)
List pgsql-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


pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [PERFORM] Simple SQL too slow
Next
From: Daviramos Roussenq Fortunato
Date:
Subject: Re: [PERFORM] Simple SQL too slow