Re: TOAST table performance problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



På fredag 07. februar 2020 kl. 15:16:13, skrev Asya Nevra Buyuksoy <ayisan1096@xxxxxxxxx>:

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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux