Re: TOAST table performance problem - Mailing list pgsql-performance

From Asya Nevra Buyuksoy
Subject Re: TOAST table performance problem
Date
Msg-id CADA48rEzqEWoJhYaTb1PU6C9=Qr8PB-SAUxA=9_vuJa5wv=ZiA@mail.gmail.com
Whole thread Raw
In response to Re: TOAST table performance problem  (MichaelDBA <MichaelDBA@sqlexec.com>)
Responses Re: TOAST table performance problem  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-performance

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>:

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.
Attachment

pgsql-performance by date:

Previous
From: MichaelDBA
Date:
Subject: Re: TOAST table performance problem
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: TOAST table performance problem