Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Joseph Krogh
Subject Re: TOAST table performance problem
Date
Msg-id VisenaEmail.26.367975a459fd47c9.1702003fe3a@tc7-visena
Whole thread Raw
In response to Re: TOAST table performance problem  (Asya Nevra Buyuksoy <ayisan1096@gmail.com>)
List pgsql-performance
Tree view
På fredag 07. februar 2020 kl. 15:16:13, skrev Asya Nevra Buyuksoy <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>:
 
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

pgsql-performance by date:

Previous
From: Asya Nevra Buyuksoy
Date:
Subject: Re: TOAST table performance problem
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: TOAST table performance problem