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
