| From: | Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Daviramos Roussenq Fortunato <daviramosrf(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Simple SQL too slow |
| Date: | 2017-07-01 21:17:02 |
| Message-ID: | 81a45651-ebf9-0df2-5351-5aa71055a58f@dalibo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daviramos Roussenq Fortunato | 2017-07-02 01:26:01 | Re: Simple SQL too slow |
| Previous Message | Tomas Vondra | 2017-07-01 20:58:30 | Re: Simple SQL too slow |