From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Subject: Re: TOAST table performance problem
Date: Fri, 7 Feb 2020 15:19:19 +0100 (CET)
Message-ID: <VisenaEmail.26.367975a459fd47c9.1702003fe3a@tc7-visena> (raw)
In-Reply-To: <CADA48rEzqEWoJhYaTb1PU6C9=Qr8PB-SAUxA=9_vuJa5wv=ZiA@mail.gmail.com>
På fredag 07. februar 2020 kl. 15:16:13, skrev Asya Nevra Buyuksoy <
ayisan1096@gmail.com <mailto:ayisan1096@gmail.com>>:
Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM:
På fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyuksoy <
ayisan1096@gmail.com <mailto:ayisan1096@gmail.com>>:
My guess is the time is spent in the client retrieving the data, not in the DB
itself. Are you on a slow network?
It works in my local area and speed is 1 Gbps. When I use another local
computer that has SSD disk the query execution time reduced to 12 seconds. But
this query has to execute my local computer.
What client are you using?
--
Andreas Joseph Krogh
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: pgsql-performance@postgresql.org
Cc: andreas@visena.com, pgsql-performance@lists.postgresql.org
Subject: Re: TOAST table performance problem
In-Reply-To: <VisenaEmail.26.367975a459fd47c9.1702003fe3a@tc7-visena>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox