public inbox for [email protected]
help / color / mirror / Atom feedFrom: Daviramos Roussenq Fortunato <[email protected]>
To: [email protected]
Subject: Re: Simple SQL too slow
Date: Sun, 2 Jul 2017 10:57:49 -0300
Message-ID: <CABFgOvrU05nRAj8ioFqv1zs65635PA5NnpgNgA7mGVk5GsASTA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CABFgOvotE9gMEkUrBwMPRs60jDiBaX5TXBiVY9jUnjHmYVRXFw@mail.gmail.com>
<[email protected]>
<CABFgOvrcpt1d5OEC5+zqiRQyy2kfvioKHXGY4Qz2kmz2AtSsLg@mail.gmail.com>
<[email protected]>
<CABFgOvoJ4EsSfCxOCm0i8+Re3V6Q9MnKR4Rj307Pjas7nCbg9Q@mail.gmail.com>
<[email protected]>
<[email protected]>
<CABFgOvo1H2WpOJd_YwAUcSEsroQDGnQuWTuJtmJSigDNOj1=2Q@mail.gmail.com>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
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 link modes: 10baseT/Half 10baseT/Full
100baseT/Half 100baseT/Full
1000baseT/Full
Supported pause frame use: No
Supports auto-negotiation: Yes
Advertised link modes: 10baseT/Half 10baseT/Full
100baseT/Half 100baseT/Full
1000baseT/Full
Advertised pause frame use: No
Advertised auto-negotiation: Yes
Speed: 1000Mb/s
Duplex: Full
Port: Twisted Pair
PHYAD: 1
Transceiver: internal
Auto-negotiation: on
MDI-X: off
Supports Wake-on: pumbg
Wake-on: g
Current message level: 0x00000007 (7)
drv probe link
Link detected: yes
# iptables --list
Chain INPUT (policy ACCEPT)
target prot opt source destination
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination
I tested the file transfer, the port speed did not exceed 512Kb/s on port
22.
I have some limitation on the network.
But I can not figure out why. This linux was installed by me, with only
minimal packages to install postgres.
What can it be?
Well it is identified that the problem is not the postgres, but the
operating systems, maybe I should look for the solution in another list.
2017-07-02 1:25 GMT-03:00 Andreas Kretschmer <[email protected]>:
> On 2 July 2017 02:26:01 GMT+01:00, Daviramos Roussenq Fortunato <
> [email protected]> wrote:
> >I am using pgAdmin for SQL test.
> >
> >
>
> Are you using real hardware or is it vitual? Needs the query without
> explain analyse the same time? Can you try it with psql (THE command line
> interface)?
>
>
> Regards, Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company
>
--
Atenciosamente
Daviramos Roussenq Fortunato
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Simple SQL too slow
In-Reply-To: <CABFgOvrU05nRAj8ioFqv1zs65635PA5NnpgNgA7mGVk5GsASTA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox