Re: [PERFORM] Simple SQL too slow

2017-07-02 Thread Daviramos Roussenq Fortunato
REAL HARDWARE. I ran the same SQL via pgsql it took only 13 seconds. My bottleneck has everything to be network. #tcptrack -i eth1 Analyzing the traffic on the network, the speed is only 512Kb / s on port 5432. # ethtool eth1 Settings for eth1: Supported ports: [ TP ] Supported

Re: [PERFORM] Simple SQL too slow

2017-07-02 Thread Nicolas CHARLES
Le 2 juillet 2017 10:39:09 GMT+02:00, Tomas Vondra a écrit : > > >On 07/02/2017 03:26 AM, Daviramos Roussenq Fortunato wrote: >> I am using pgAdmin for SQL test. >> >> Linux: >> >> EXPLAIN ANALYZE select * from >> "Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774 >> width=92) (a

Re: [PERFORM] Simple SQL too slow

2017-07-02 Thread Tomas Vondra
On 07/02/2017 03:26 AM, Daviramos Roussenq Fortunato wrote: I am using pgAdmin for SQL test. Linux: EXPLAIN ANALYZE select * from "Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774 width=92) (actual time=0.016..1194.453 rows=1883699 loops=1)" "Total runtime: 2139.067 ms" Wind